I have an SSAS cube which has Facts and Dimensions for two topics (Sales and Marketing). Each topic has its own facts and dimensions and there are some common dimensions too. Is there a way to categorize the Facts and Dimensions within the cube according to topic, in such a way that my Cube looks like this -
Sales
Fact-1 Dimension-1
Marketing
Fact-2 Dimension-2
Common Dimensions
Dimension-3 Dimension-4