Skip to Content

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.



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:



    Add comment
    10|10000 characters needed characters exceeded