subset in view and collapsing expending aggregation elements

Post Reply
EP_explorer
Regular Participant
Posts: 221
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

subset in view and collapsing expending aggregation elements

Post 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 2461 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 2461 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?
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: subset in view and collapsing expending aggregation elem

Post 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.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply