0
votes

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

1

1 Answers

0
votes

If you have Enterprise edition you can create a Perspective for Sales and one for Marketing. Users will choose to connect to the appropriate perspective instead of the whole cube. Each perspective just shows a trimmed down field list.