Ability to assign 'selector' widget element as a variable to MDX view in PAW

[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?

[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.

[lotsaram]

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.

[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