Skip to Content
avatar image
Former Member

setVariable/setfilter spend too much time in DS

Hello everyone.

I'm use SAP BusinessObjects design studio 16.5 to develop report,and I'm use http OLAP to connect HANA. When I filter the datasource,I just use DS.setFilter or APPLICATION.setVariable,I hava 5 different datasource,and all of them have a variable(

Z-site),and I have set them in different datasource group.But when I use setFilter to filter datasource,which average filter cost 3.4s,when I change to APPLICATION.setVariable("Z-SITE","2001"),it spends 20 seconds,and most time spend there.Application.setVariable() shouldn't run all variabes in datasource that the variable name is same?

Waiting for your help.

Thanks.

Jing

table.png (32.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 05, 2017 at 04:00 AM

    Hi Jing,

    Some points to note:

    1) In general, setFilter() always performs better than setVariable();

    2) If you are taking advantage of the parallel processing groups, then since prompts are not merged, I would expect all common variables to be run in separate variable containers, perhaps explaining your performance issue;

    3) The following blog posts may help you optimise your data loads based on processing groups:

    https://blogs.sap.com/2015/09/28/parallel-processing-and-scripting/

    https://archive.sap.com/documents/docs/DOC-63888

    https://archive.sap.com/documents/docs/DOC-64462

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Mustafa Bensan

      Hi Mustafa.

      Follow is my code.

      APPLICATION.setVariableValue("Z_SITE", "2001");
      APPLICATION.loadDataSources([DS_2,JR,JRYD,YD,XC]);

      Regards.

      Jing