Query runtime issue

[Former Member]

Hi All,

I have a query which on executing in RSRT has a runtime of 33 seconds. On the other hand when i run the same query in BEx Analyzer the query takes 2 min 30 seconds for the variable screen to appear. Can you please let me know whether there are any settings to be done for solving/determining this runtime difference.

Thanks,

Harshal

[michael_devine]

Hello Harshal,

Apply these parameters in the system to improve the backend <-> frontend communication.

ANA_USE_SIDGRID      Value: "X"
ANA_USE_SIDGRIDDELTA Value: "X"
ANA_USE_SIDGRIDMASS  Value: Boolean ("X")
ANA_USE_SIDGRIDWBUF  Value: "X"
ANA_USE_TABLE        Value: "X"
ANA_CACHE_WORKBOOK   Value: "X"

Refer to Note 1510916 for more descrition on the RS_FRONTEND_INIT.

Regards,

Michael

[Former Member]

Hi Harshal,

Please check your BEx version. May be you can install basic version and then try. What is a case if u run report using a Web link?

Regards,

Ganesh