CODEWITHSUNDEEP
sql-server-2008-r2ssasdata-warehouseolap-cube
RASMiranda
RASMiranda

Reputation: 381

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?

Upvotes: 0

Views: 488

Answers (1)

Prabhash Jha
Prabhash Jha

Reputation: 340

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.

Upvotes: 1

Related Questions