Business Intelligence and Analytics (RSS)

Thursday, March 20, 2008 3:15 PM

Forget SQL Management Studio, Stick to BIDS

Ok, so lately there has been a decent bit of frustration from our crew about how to deploy a Analysis Services Project from BIDS to XMLA without going into SQL Management Studio and going through that whole mess.  Well my fellow coworker Xander got
posted by adron | 2 Comments
Filed Under: ,
Monday, February 25, 2008 10:45 AM

SQL Server Analysis Services Authentication Freak Out

[Rant On] What is the deal really with the anti-user intuitive situation with analysis services when it decides that the data connection to a data source needs to use some arbitrary user authentication!  I had my SSAS cube set to process against
posted by adron | 0 Comments
Filed Under: ,
Tuesday, February 05, 2008 9:18 AM

Pre-existing Cube into Visual Studio Project?

I got to wondering, and realized it is not straight forward or even possible.  How does one go about bringing an existing SQL Server Analysis Services Cube into a new Visual Studio Solution or Project? ...this one I'll have to dig on, so far, nothing
posted by adron | 1 Comments
Filed Under:
Wednesday, January 23, 2008 10:04 AM

Common Sense Cardinality

I've been hearing a lot of discussion about cardinality this and cardinality that. With the topic becoming such a common point of discussion. I decided I would write up something. First some definitions so that we all have a clear cut idea of what cardinality
posted by adron | 0 Comments
Filed Under: ,
Tuesday, January 08, 2008 5:56 PM

Unit Tests Don't Work on Cubes

I've been building web sites for a while now.  I've been writing code, object oriented style for the better part of a decade.  Unit testing I've been doing for all of about 1-2 years to various degrees.  Nothing super advanced yet, and
posted by adron | 4 Comments
Filed Under:
Wednesday, December 26, 2007 11:54 AM

Index, Fragmentation, Statistics - A List

This entry is going to be a collected list of practices for index, fragmentation, statistics, and general VLDB table and view maintenance. First off, a few obvious index practices. If a non-clustered index is not used, toss it.  When a table has
posted by adron | 1 Comments
Filed Under: ,
Wednesday, December 26, 2007 11:00 AM

BI Applications?

It seems that everywhere one looks in the ETL/OLAP/BI Industry Space there are no real canned applications.  When I say canned application I'm talking about an application that from the ground up is all inclusive, managing the database, the ETL,
posted by adron | 1 Comments
Filed Under: ,
Tuesday, December 18, 2007 10:55 AM

SaaS is Alive and Rocking!

SaaS, or Software as a Service, isn't new.  But it sure seems to be that way with what is coming from that software model these days.  It finally has grown legs and is taking off running. One of the services that SaaS can provide is business
posted by adron | 1 Comments
Filed Under:
Wednesday, November 21, 2007 9:24 AM

BIDS Helper, "I Found My MDX!"

I was complaining recently about getting MDX a week or so ago.  I wanted MDX generated from my Cube in BIDS.  Well I found a kick butt tool that helps one do that.  Not only does it help with getting the MDX, but it also provides printer friendly dimension
posted by adron | 0 Comments
Filed Under: ,
Monday, November 19, 2007 1:53 PM

Analysis Services Performance Testing and Artsy Things

I'm on a couple new quests as of this week.  One is to find a decent way to performance test SSAS without buying or putting in place large servers similar to what would be used in a production environment.  The second is to figure out how to have JavaScript
posted by adron | 0 Comments
Filed Under: , ,
Wednesday, November 14, 2007 9:00 AM

Cube Design Best Practice :: Tip o' The Day

Do not put too many parent-child dimensions in a cube. This tip is magnified when the dimension contains custom rollups or unary operators.  Yes, some of you might say, "but they are so powerful!"  Well with power comes responsibility!  In this case the
posted by adron | 0 Comments
Filed Under: ,
Monday, November 12, 2007 3:16 PM

Multi-Cube

So I got to thinking, and after searching around a bit, I didn't find much, "A blog post is in order!"  So here is what I was researching. Where and when is it a good idea to start breaking out to multiple cubes? What is the best practice about splitting
posted by adron | 1 Comments
Filed Under: ,
Friday, November 09, 2007 10:43 AM

Numeric Keys RULE! :: Tip O' The Day

When you're developing attributes that have a bunch of members, let's say more than a million (1,000,000,000), you should definitely use numeric keys.  Don't use strings or anything like that or you will suffer delays.  With business intelligence cube
posted by adron | 0 Comments
Filed Under: ,
Friday, November 09, 2007 10:40 AM

Lacking MDX Contemplations

So here I am plugging in some dimensions and getting some measures in Visual Studio when I stumble on the fact that I can't get the MDX from what I'm doing.  What should I use to do this? One tool I know that will get the MDX for a report is ProClarity,
posted by adron | 4 Comments
Filed Under: ,
Wednesday, November 07, 2007 1:37 PM

Pretend T-SQL BI Queries

Often times there is no cube, no OLAP, no BI plan but someone wants reports that provide rollup data, data slices, sums, and even dimensional representations that are oriented toward the BI world.  Of course building these in SQL is possible, even easy
posted by adron | 0 Comments
Filed Under: ,
More Posts Next page »