SSAS: One giant cube or many small ones?
When using SQL Server Analysis Services (SSAS) to build a cube, you may start out with one fact table, but then decide to add another fact table. You are then faced with a decision: Do you add that fact table to your existing cube and have multiple measure groups, or do you create another cube, each with a single measure group? An example would be if you create a cube with financial data, and then a request is made to have a cube with operational data. Should you put the financial data and operational data together in one cube, or have two cubes, a financial cube and an operational cube? Here is a list of the benefits and disadvantages of both approaches:
Read more...Tags: design, management, cube