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?
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.