2024 Jun 08 11:02 AM - edited 2024 Jun 08 11:04 AM
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
Request clarification before answering.
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()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 18 | |
| 8 | |
| 6 | |
| 6 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.