Page 1 of 1

subset in view and collapsing expending aggregation elements

Posted: Thu Apr 17, 2014 1:06 pm
by EP_explorer
I want to do next thing:
To show In Contributor elements in dimensions (time periods) which would be shown depending by current time

For example - I show 1 Quarter and its months at the 1 Quarter, 2 Quarter at the 2nd etc.
I did MDX based subset which shows necessary Quarter and its months which depends of the current time and created view with the subset

Next - screen from sample Sdata model with view based on the subset 1 Quarter:
01.JPG
01.JPG (27.29 KiB) Viewed 2460 times
Next come against next problem: I simply collapse and expand 1 Quarter element, click refresh and see that view doesn't base on the subset 1 Quarter
02.JPG
02.JPG (26.49 KiB) Viewed 2460 times
So when the subset 1 Quarter will be changed (in the second Quarter) it will not affect current view for user.

Is it possible to do that view in Contributor based on subset haven't been changed after collapsing, expending aggregation elements?

Re: subset in view and collapsing expending aggregation elem

Posted: Thu Apr 17, 2014 3:29 pm
by jim wood
By changing the elements within the subset, you are moving away from the subset that's why the name changes. I'm not sure how you would work around this. It's similar in the SubNm formula, if you go in, select all and then select an element the subset name is no longer in the forumla once you return to the sheet.