Skip to Content
0

Hierarchy Prompt performance issue - Analysis Office & HANA Sidecar

Apr 05, 2017 at 02:49 PM

120

avatar image
Former Member

We currently have a on premise solution of HANA 1.02.06 and Analysis Office 2.4. We are using calc views including those delivered as HANA LIVE views.

We are seeing two issues with Hierarchies and prompts:

ISSUE 1] From the prompt dialogue when the user chooses to display "Leaves" instead of "Hierarchy" the system takes about 5 minutes to respond. Reverting from Leaves back to Hierarchy is under 10 sec.

ISSUE 2] The values selected at the prompt screen are not filtering or having any affect on the displayed data.

I have researched all online forums and found a similar issue with AO and BW HANA however the fix is to apply a patch on BW which we so not have the system.

Thanks for any help

10 |10000 characters needed characters left characters exceeded

Chuck - I wonder if you could turn on profiling for Analysis Office, as Sowjanya mentions in her blog here - https://blogs.sap.com/2016/08/25/check-profiling-statistics-in-analysis-for-office-to-improve-performance/ - what are the results?

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers