Page 1 of 1
Ability to assign 'selector' widget element as a variable to MDX view in PAW
Posted: Mon Jul 15, 2024 8:19 pm
by bubidibabadi
Hello TM1 folks,
Is it possible to dynamically assign the element in the 'selector' widget as a variable to the MDX view? For ex, if I change the month to 'Feb', I want to see Feb, Q2(current Quarter) and YTD in the view. Can PAW do this?
Re: Ability to assign 'selector' widget element as a variable to MDX view in PAW
Posted: Tue Jul 16, 2024 3:15 am
by JohnO
Very recent addition to PAW
https://www.ibm.com/docs/en/planning-an ... ierarchies
So this supports the base cases and is much better than before (ie: nothing). What it doesn't allow is the setting of custom MDX in the target view with a dynamic parameter where that parameter can be passed by a selector widget - which is what I was hoping we might see.
Re: Ability to assign 'selector' widget element as a variable to MDX view in PAW
Posted: Tue Jul 16, 2024 8:29 am
by lotsaram
JohnO wrote: ↑Tue Jul 16, 2024 3:15 am
Very recent addition to PAW
https://www.ibm.com/docs/en/planning-an ... ierarchies
So this supports the base cases and is much better than before (ie: nothing). What it doesn't allow is the setting of custom MDX in the target view with a dynamic parameter where that parameter can be passed by a selector widget - which is what I was hoping we might see.
If you need and want this there are other GUIs to Planning Analytics which do offer this functionality.
Re: Ability to assign 'selector' widget element as a variable to MDX view in PAW
Posted: Tue Jul 16, 2024 8:37 am
by MarenC
Hi,
One way around this problem is to make the Selector Widget a Cube view which includes the client dimension and the measure a picklist of the months, and then have the MDX in the main view reference this.
Maren