Rolling time period using a dimension filter - Application error

[former_member486909]

Hi All,

I am trying to display rolling 13 months with reference to the month selected in the dimension filter. The code that I am using for the OnApply event of the dimension filter is:

APPLICATION.setVariableValue("ZE_CALMON", DS_ALL_MAIN.getFilterExt("0CALMONTH"));

However, whenever I am using the above or code similar to above I am getting the error "The Application does not exist.....". While processing the current request, an exception occurred which could not be handled by the application or the framework.....

This error is not appearing when I am removing the above code..it is occurring when I write Application.setVariable

I am not getting any code error .....I have tried the option of setting "load in script" to true but of no help.

Any idea why am I getting this error?

Thanks in advance

Swasti

[Former Member · Accepted solution]

Hi Swasti,

Did you use VariableValueExt?

Regards,

Fazith Ali Z

[former_member486909 · Accepted solution]

Hi Fazith,

I just modified the query to

APPLICATION.setVariableValueExt("ZE_CALMON", DS_ALL_MAIN.getFilterExt("0CALMONTH"));

Now, I am not getting the error "Application does not exist"...But, rolling month functionality is not getting implemented. The data set is getting filtered for only the month selected in the filter.

Thanks & Regards

Swasti

[Former Member · Accepted solution]

Sorry Swasti, I forgot the Dimension filter part, the Dimension filter should then have a Unique Dummy DS, if you do it on the Data source which runs a Chart or Crosstab, you are going to end up with only the single month

Regards,

Fazith Ali Z.

[former_member486909 · Accepted solution]

Thanks a lot Fazith, the solution worked!

Regards,

Swasti

[Former Member]

Hi Swasthi,

Does the Dimension Filter type has function ..to read the runtime selected values. I have a similar requirement where I need to read what is selected at runtime in the Time Dimension(I have Months/Periods).

I am using the following.

STR is a string global variable..REVCY_EXP is the datasource for chart and TEST is the datasource for dimension filter field.

Idea is to capture selected values into STR and pass them to the Chart as the source.

STR = TEST.getFilterExt("/CPMB/NDD9Q3V");

REVCY_EXP.setFilterExt("/CPMB/NDD9Q3V", STR); it shows error...

If you know how to debug the script with breakpoints, can you pls share some tips.

Regards,

Krishna

[Karol-K]

Hi Krishna,

can you place this line below your first "get" function:

STR = TEST.getFilterExt("/CPMB/NDD9Q3V");

APPLICATION.createErrorMessage("Value: " + STR);

then, if you have some error, at least post the message of it and attach the complete callstack.

reg, Karol

[Former Member]

Hello,

I did add that statement and it returned me the following

• VALUE :1415.APR; 1415.MAY; 1415.JUN.

  This is exactly what I want to pass (I selected these 3 time periods in the Time dim) to the chart.

  For passing the above values in the STR variable, I am using this in the Data binding area DataSelection : {"/CPMB/NDD9Q3V": +STR } Does it replace STR variable with all these values ?

  I am trying it anyway. Will update. I am not able to know how I can pass the STR variable into the chart.

  DataSelection : {"/CPMB/NDD9Q3V": +STR } does not work. It gives error. I tried without + sign as well.

  Thanks for the pointer.
  

[Karol-K]

Hello Swasti,

you can try to use my "Simple Date Object" component to roll dates as you want.

The tricky point is in your scenario to calculate the months based on selection, this can be done via scripting (you would need to implement date logic) or use the component.

does this help?

Regards, Karol