Scripting functions let you configure and automate custom actions on a plan item during its initial load, when its data changes, or when you select a button or toggle. For example, you can display a specific sheet on an item's initial load, display custom messages, show or hide one or more measures, or set a layout in response to these events.
Use scripting functions while configuring action parameters to define the actions you want to execute in response to the events.
Some scripting functions operate at the ROOT level of the plan item, while others operate at the planning sheet level. The following sections describe each scripting function with examples.
Use SHOW_MESSAGE to display a toast message to the users.
SHOW_MESSAGE("<message>")Create an action parameter. Select Enable Script and Execute on Initialize. Select Add to add an action.
Use a , on-load, and on-data-change scripts to create Inforiver filters without requiring access to the toolbar.
OPENFILTER()Create a button variable to call the OPENFILTER function.
Users can click the Filter button variable and need not depend on the toolbar to apply custom filters.
Use variables, on-load, and on-data-change scripts to open the KPI Explorer without requiring access to the toolbar.
OPENKPIEXPLORER()Create a button variable to call the OPENKPIEXPLORER function.
Users can click the KPI Explorer button variable and do not need access to the toolbar to use the KPI Explorer.
