analysis services - hierarchy from more than one dimension.

Posted on 2007-10-10
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

    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
    LVL 1

    Expert Comment

    Forced accept.

    EE Admin

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now