analysis services - hierarchy from more than one dimension.

Posted on 2007-10-10
Medium Priority
Last Modified: 2013-11-16
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:
For eg:
Daily Accounts Fact table
Region dimension
Product Company dimension
Product Type dimension
all three dimensions are linked to fact table,
How do I create Region-Company-Type hierarchy.

Pls help.

Question by:jmrkavi
LVL 18

Accepted Solution

PFrog earned 200 total points
ID: 20047581
You should not have a single hierarchy crossing unlinked dimensions.
If you want the cube to control this hierarchy you will need to redesign the cube so that it actually represents your data. i.e. either build a star schema, with your dimensions daisy-chained to each other, or (preferably) de-normailise your datasource so that region and company type are attributes within the same dimension (be sure to set up your attributes relationships correctly).

However, you can create a hierarcy crossing dimensions within a client viewer (either BIDS or Excel etc.)
Just drag all the attributes that you want in the hierarcy into the row or column of a pivot

Expert Comment

ID: 20649826
Forced accept.

EE Admin

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question