Skip to Content

Analysis for Office - Prompt/Variable screen issue

Feb 23, 2017 at 03:36 PM


avatar image

Dear colleagues,

I am facing the following issue when running planning report in Analysis for Office

I have a characteristic in prompt screen, Project, which property "Filter Value Selection at Query Execution" is defined as "Values in Master Data Table".

Currently MD table only contains 500 records.

However, when clicking question mark for displaying MD values, it takes up to 20 seconds.

There is a significant difference if I run the query in RSRT. Values are displayed in less than three seconds.

Test with "old" Analyzer shows up same result: Less than 2-3 seconds for displaying MD values.

Any idea what could be the cause of this huge difference?

I have tried to use RSTT or check profiling statistics, but I couldnt manage to track the issue.

Thanks and Regards,


10 |10000 characters needed characters left characters exceeded

Francis, would you run profiling statistics as Sowjanya describes in her blog? - that might determine the bottleneck...

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

2 Answers

Francisco Estevez Feb 24, 2017 at 09:13 AM

Good morning Tammy.

Thanks for your prompt reply.

I have run profiling statistics and identify root cause.

There is an issue with function module BICS_PROV_GET_MEMBERS. Very slow performance.

I have searched in OSS notes and there are several ones with similar issues regarding displaying LOV.

We will raise a new one as it is a problem not solved.

We are in SAP BW 7.5 SP3.

Thanks and Regards,


ac6nf.png (105.2 kB)
10 |10000 characters needed characters left characters exceeded
Francisco Estevez Feb 28, 2017 at 10:38 AM

Issue is fixed changing Excel Analysis settings --> User --> Maximum Number of Members Displayed in Filter Dialog.

10 |10000 characters needed characters left characters exceeded