Hi Folks,
Requirement:
there is a custom variable called WeekNumber from BW that is to calculate number of open order Quantity based on weeks.
eg.., if story variable is set to 5 it will sum up open order quantity for upcoming 5 weeks
1. Using input field user can able to update the chart variable. instead of going to edit prompt or chart variable.
Created a text box and entered the following script, it working but its applying for story variable, I have multiple widgets so its takings 20 seconds to initialized. Please find the script below
weeknumber= ConvertUtils.stringToInteger(InputField_1.getValue());
Chart_2.getDataSource().setVariableValue("ZFVWEEKNUM",weeknumber);
Chart_2.getDataSource().getVariableValues("ZFVWEEKNUM");
Chart_2.getDataSource().refreshData();
Loading Optimization Settings : Background Loading.
In the above code I have mentioned that set variable value to apply only for chart2 to but it is applying for all 32 widgets .
Please help me to update only chart variable.
