Performance issue with BPC reports created with EPM add in for Excel

[former_member598027]

We have BPC reports build via EPM Add in for excel through local connections over Virtual providers. We experience serious performance issues on building reports which involve dimension object values at the higher most level of the hierarchy. For EG: we have a dimension Management where top most aggregated level is "Total Management" and we have 4-5 sub levels under them like "Europe", "Asia", "Africa", "US" which In turn have multiple sub levels. If we try to create the BPC report with "Total Management" value from the dimension Management, the reports takes 3 minutes. Where if we pull in the lower most levels of values from the sub category "Europe", "Asia", "Africa", "US" , the reports runs under 1 minute.

In addition to that the reports built on standard cubes instead of virtual provider run under 30 seconds.

We went through various SAP notes which talk about BPC reporting performance and identifying the route cause for performance via ST12 tracing. We tried extracting the ST12 trace information for ABAP, Performance, SQL and found that the MDX Program BAPI_MDDATASET_GET_CELL_DATA under Performance trace was taking most of processing time(172 secs). We went through below SAP notes and none of the cases in the notes match our performance issue from ST12 tracing.

2272366
2584917
2248989
Is there any way or SAP note which talks about improving the MDX program BAPI_MDDATASET_GET_CELL_DATA's performance?

Version details

BPC 10.1

CPMBPC810
BW 750

EPM 10.0 SP33 Patch 3 .NET4.5 x86

[former_member314654]

Hello,

Investigating and pin pointing the reason for performance issue is always challenging because of number of variables involved in the process.

They could be front end(EPM add-In) back end (application or DB) or local machine or local network, wired vs wi-fi etc

did you try analyzing the issue by running the fiddler tool? try this if not already done.

1766704 - How to use Fiddler to collect HTTP and HTTPS traces

Is it just that one specific report when hierarchy is selected or across the models and other reports too?

did you try setting the Hierarchy level to 1 as a default view? once report is executed users can double click on the node and further expand the to any level they want.

hope this helps!

Regards,

Ellora