Search code examples
sql-server-2008-r2ssasdata-warehouseolap-cube

OLAP Cube: per Business Process? per Fact table?

So i've finished my dimensional modeling, it resulted in 2 business process, 1 simple with only one fact table and a few dimension, the other one a bit more complex with 2 fact tables (related in a similar way has Invoice and InvoiceRecord) and a lot more dimensions.

My question now is how to start building the OLAP cube(s), one for each Business Process? Or one for each Business Process and for each fact table?

Solution

  • You need to consider all the fact tables and dimensional tables for creating a common star schema. You should consider creating single cube unless fact and dimension pairs are not interrelated at all. It all depends on your design.