Post reply

Hierarchy, Attributes and browsing levels in isolation

  • September 15, 2016 at 8:28 am

    #151018

    I have just started building my first cube on Visual studio 2015 and need some assistance;

    I have a product dimension with a hierarchy on Product/Item/Category set up. When browsing a level in isolation, eg Category, I would want to return the results regardless of the levels above as it would do if it wasn't in a hierarchy

    For example data as below

    Product / Item / Category / Quantity

    A / AA / AAA / 1

    A / AB / AAA / 1

    I want it to return the below, in the browser, as it would if it wasn't in a Hierarchy

    Category/ Quantity

    AAA / 2

    Yet it returns

    Category / Quantity

    AAA / 1

    AAA / 1

    I assume it is doing this as the item is different on two lines. Is there any way to get round this or is it a consequence of using Hierarchies?

    Thanks in advance

  • September 15, 2016 at 9:04 am

    #1901141

    Interestingly enough, the behavior is due to the attribute relationships and not the hierarchy. Have a look at the following post...following a similar approach would give you the required behavior: http://www.sqlservercentral.com/Forums/Topic1802971-17-1.aspx

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

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