cancel
Showing results for 
Search instead for 
Did you mean: 

Analysis for OLAP - HANA - Performance Issue

Former Member
0 Kudos

Hi Experts,

i have a performance issue using Analysis OLAP on HANA view: when i drag a dimension in the background section, is necessary to wait a lot of time and usually BI goes in error with timeout message.  

The BI release is 4.1 SP4 and HANA is in SP7.

Thanks.

Andrea

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Does it happen with a specific dimension? If you have analysis for excel, do you have this problem there?

Former Member
0 Kudos

Hi Andrea,

That's a bit odd. How big is that dimension? As you know, when you add a dimension to the background it automatically opens the member selector allowing you to pick the appropriate members.

The member selector can be tuned by changing the properties of the MDAS service. If you look at section 7.7.1 in the Admin guide entitled "Maximum number of members returned when filtering", you'll see how to reduce the number of members returned. This may help with your issue.

http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp1_aa_admin_en.pdf

Best regards,

Philip

Former Member
0 Kudos

We have this performance issue after the upgrade to SP4.

Former Member
0 Kudos

Hi Philip

the dimension contain 270000 element about.

Andrea