Two dimension hierarchies reference one dimension table

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  analysis services   » Two dimension hierarchies reference one dimension table

Two dimension hierarchies reference one dimension table

Topic RSS Feed

Posts under the topic: Two dimension hierarchies reference one dimension table

Posted: 5/30/2012

Jedi Youngling 2  points  Jedi Youngling
  • Joined on: 6/8/2011
  • Posts: 1

I want to create two dimension hierarchies that reference one dimension table based on different values within the same field, ex. 1 = Financial and 2 = Production.  This dimension maps to the same fact table.  When we bring over the hierarchy for Financial, I only want to see financial and when we bring over the hierarchy for Production, we only want to see Production data.  How do you accomplish this is in AS?


Posted: 6/1/2012

Padawan 1251  points  Padawan
  • Joined on: 4/22/2010
  • Posts: 23

This sounds like a role playing dimension to me.  In the fact table are there seperate columns for Financial and Production?  If this is the case, create the relationships, bring the tables into the dsv, build your cube and AS will automatically create the seperate dimensions (Financial, Production) for them.


Page 1 of 1 (2 items)