Performance issue in AO 2.3 SP2 Patch 1

[former_member590334]

Hi All,

We are on HANA 1.0 SPS 12 and using Analysis for Office 2.3 SP2 Patch 1 for reporting.

We have developed a simple calculation view of type CUBE. The data volume us also very less (approx 60K records).

When I execute this calculation view in HANA i get output in 2 seconds.

Same view when I execute in Analysis For Office it takes more than 2 mins.

Could you please provide some insights on why this view is taking more time in Analysis for Office?
Is there a way to optimize the report performance in AO.

Thanks,

Abhigya

[TammyPowlas]

Hi - you asked a similar question here: https://answers.sap.com/questions/616003/performance-issue-with-aoffice-report.html

Please update to 2.6 Analysis Office, latest SP and try again