analysis services - hierarchy from more than one dimension.
Posted on 2007-10-10
new to analysis services 2005.
I have got a fact table which is linked to various dimension tables. I would like to create hierarchy from one or two dimensions:
Daily Accounts Fact table
Product Company dimension
Product Type dimension
all three dimensions are linked to fact table,
How do I create Region-Company-Type hierarchy.