Skip to Content

Analysis for Office - Prompt/Variable screen issue

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,


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • 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)
    Add comment
    10|10000 characters needed characters exceeded

  • Feb 28, 2017 at 10:38 AM

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

    Add comment
    10|10000 characters needed characters exceeded