Skip to Content
0
Aug 17, 2023 at 03:37 PM

waiting for all widget to be initialized because set variable is called in sac script

136 Views Last edit Aug 24, 2023 at 09:10 AM 2 rev

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.

image.png

Attachments

image.png (23.0 kB)