Skip to Content
Feb 23, 2017 at 03:36 PM

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,