My company uses SQL Server 2008 R2 Enterprise Edition.
I received data and a model from another agency and I have to mount the Data Warehouse to provide my company members the BI solution.
In this model there is a constelation with 21 stars. I thought I would create 21 cubes in BIDS and then link them later. But it seems there is no way to do it in SSAS. Every star is related with, at least, another star.
What is the best strategy to create it? Should it be one unique cube with 21 fact tables?
A piece of the model is attached, but the names are in portuguese.
Thanks in advance