cancel
Showing results for 
Search instead for 
Did you mean: 

Performance Issue with AOffice report

0 Kudos

I am able to execute the calculation view output in some 2 secs but the report is taking 1.52 mins to load the data in AOffice 2.3 SP2 Patch 1.

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member302041
Contributor
0 Kudos

Hi,

Is AO connected directly to HANA view or using BW BEX query?

BR,

0 Kudos

Hi Andrew..AO is directly connected to HANA view..

former_member302041
Contributor
0 Kudos

Not sure, but may be profiling and statistics can give you at least a direction.

Look at the following WIKI...

https://wiki.scn.sap.com/wiki/display/BI/Profiling+information

BR,

0 Kudos

Hi..Hana end we have already checked and it is taking less than 2 seconds to execute....Thanks

TammyPowlas
Active Contributor
0 Kudos

Hello, 2.3 is really old; please try this with the latest SP with 2.6 or 2.7 Analysis Office version

0 Kudos

Hi Tammy,

We have large user base hence upgrading to higher version of AO is not possible immediately.

Our other reports are working fine and we are facing issue with this report alone.

At HANA end every thing looks ok.

Regards,

Abhigya

TammyPowlas
Active Contributor
0 Kudos

My guess is the issue is on the HANA back end and not Analysis Office. What troubleshooting steps have you taken on the HANA side?