Hello Dashboard Gurus ,
I am currently on Design studio 1.6 SP2 Patch 1 . Here is the scenario we have -
The Dashboard is a 4 quadrant single page dashboard which shows 4 charts for historical performance and 4 KPIs on top to show current performance .
We have a initial prompt screen that asks for prompt values and the dashboard in turn runs all the datasources at startup and displays everything at one shot .
There are two BEx queries we have identified who are slower than the rest and causing the slowness in the dashboard .
To address this we decided to unmerge the prompts and apply parallel processing .
All the queries have same prompt . So I decided to have 'Load in script' - False for one query and True for all the other BEx queries.
At the Application level these are the settings we have -

Only One Prompt is kept . The one which is defined as 'Load in Script' - False

The DataSources are defined in Processing Groups like this

At application startup we have simple script like this APPLICATION.loadDataSources([SPEND,SPENDPPVMATERIAL,SPENDPPVPLANT,SPENDPPVPURGRP,MATERIALSPEND]);APPLICATION.setVariableValueExt("CICFCMCOMCO",VENDPERF.getVariableValueExt("CICFCMCOMCO"));APPLICATION.setVariableValueExt("FIGLCMFYR",VENDPERF.getVariableValueExt("FIGLCMFYR"));
When we run the dashboard all seem fine -

We also have a Dashboard 'refresh' option . hitting which should open the prompt screen again and user should be able to provide new values to re-run the dashboard . But problem lies here . The Refresh button has script like this -
VENDPERF.clearAllFilters();
APPLICATION.openPromptDialog();
APPLICATION.setVariableValueExt("CICFCMCOMCO", VENDPERF.getVariableValueExt("CICFCMCOMCO")); APPLICATION.setVariableValueExt("FIGLCMFYR", VENDPERF.getVariableValueExt("FIGLCMFYR"));
When we hit the refresh button the Prompt screen gets totally broken .Have anyone faced this issue ? It keeps on breaking at the drop of a hat and there is no clear way of fixing this . The only approach sometimes seem working is to re-define the prompt from scratch . Am I doing something wrong code-wise?

Add comment