Query Stripping in Web Intelligence

[Former Member]

Hi,

I am unable to see Query Stripping option.

Is it only available for particular database?

What is the use of this?

Please let me know?

Thanks and Regards,

Manjunath N. Jogin

[Former Member · Accepted solution]

Query Stripping enables you to optimize the query generation automatically.

It improves the performance of the report by sending the stripped query to the connection server.

Each time you refresh a query, Web Intelligence strips the objects which areb not contributing to the report (directly or indirectly) from the report as well as from the SQL Viewer tab. It refreshes only the query that is directly related to the report.

You can get Enable Query Stripping in the Query property.

At the document level , select Enable Query Stripping in the Document Properties tab.

u2022 Query Stripping is applicable only for OLAP database users.

u2022 In a Query Stripping enabled document, if a query filter is used on a Measure object, Web Intelligence does not strip the objects.

[Former Member]

Please see the following SCN article for an SAP Analytics YouTube video demonstrating how to enable Web Intelligence Query Stripping (as well as other Web Intelligence performance-tuning settings) in BI 4.0:

http://scn.sap.com/message/13988848#13988848

[Former Member]

Query Stripping is a new feature that is available on XI3.1 SP3 and BI4.0

Query Stripping feature optimizes the query to fetch only DATA which will be directly or indirectly rendered or displayed to the User, thus decreasing the response time and faster display of the report for the user. This feature is only available for OLAP universes, and it will be greyed out when using any RDBMS universe