May 23, 2008 at 6:36 am
hi mates,
I want to know whether we can have more than one fact table in a cube...and also the maximum dimension table we can have in a cube....I had created a cube using cube wizard ..what type of cube it was....lots of confusion in defining the different types of cubes in MSDN...Help me out in this as am a new bie in SSAS...
cheers mate
vijay
May 23, 2008 at 8:45 am
Analysis Services can get complicated, I would suggest you get a book or take a class.
As for your questions, you can have multiple facts tables in a single cube. I do not think there is a published hard upper limit on the number of dimension tables in a cube (although I suspect it may fail at some point), but the performance of your cube will degrade exponentially with the number of dimensions you do have.
In truth, the number of exposed attribute hierarchies is really more the limiting factor. The more attribute relationships you have, the more possibilities AS will have for aggregations. The first issue you will run into is an eventual inability for the tools to make a decision in a timely manner of which aggregations to create (so you have to create them manually). The issue you will have after that will be you have created so many aggregations that your cube processing never finishes, or you do not have enough aggregations and your queries always end up summarizing data at the lowest level.
It's a balancing act that you have to manage and it will be different for every cube.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply