Post reply

what is the difference between attribute hierarchy and user-defined hierarchy

  • March 31, 2010 at 5:57 am

    #217213

    what is the difference between attribute hierarchy and user-defined hierarchy

  • March 31, 2010 at 7:10 am

    #1143055

    Quote from MS TechNet:

    By default, an attribute hierarchy is created for every attribute in a dimension, and each hierarchy is available for dimensioning fact data. This hierarchy consists of an "All" level and a detail level containing all members of the hierarchy. [...], you can organize attributes into user-defined hierarchies to provide navigation paths in a cube.

    So, each attribute is in fact an attribute hierarchy: the all-level and the members of the attribute. (for example: (All - red, blue, yellow, ...)

    The user-defined hierarchies are the ones you create in the hierarchy pane of your dimension in SSAS. (for example: Product - Subcategory - Category)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 31, 2010 at 7:14 am

    #1143056

    SQL Server will create a hierarchy (usually 1 level) for pretty much all dimension attributes. A user defined hierarchy is something you create and can have multiple levels for example City, State/Province, Postal Code

    http://technet.microsoft.com/en-us/library/ms166717.aspx

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply