cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to update input Control values through Script looking Filter Panel Dimension member Values

Vasu_Sac
Participant
0 Kudos
2,017

Hi

I have Story Filter Panel and page input controls in my planning story. I am looking to update input control dimension member values to update based on user selection of Story Filter dimension.

Ex, Filter Panel having Country Dimension and Input Control having Sales Org Dimension.

If GB country selects, Sales orgs should update SG1, SG2.

If FR country selects Sales orgs should be SG3, SG4.

I checked Filter Panel and it doesn't contain any script events. and Input control only having On Select Event.

How to script this and which events to write. 

Regards,

Vasu

View Entire Topic
Ilya_G
Explorer
0 Kudos

try to read Country story filter like this:

Application.getFileDataSource("modelID").getDimensionFilters("dimension")

next you can write IF statement for different values of the countries and set the corresponding filters to Input Control

InputControl_2.getInputControlDataSource().setSelectedMembers()

or directly to orgs in the charts using this

Chart_1.getDataSource().setDimensionFilter()

But if your Chart_1 always has country = #, then it will not work as you have filtered this in the filter panel to GB or FR, so I would suggest you to use the selection of the Country in an Input Control configuring Linked Analysis setting for it to work for selected widgets only, and next reading a Country from this InputControl using this:

InputControl_1.getInputControlDataSource().getActiveSelectedMembers()