September 15, 2016 at 8:28 am
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
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