Skip to Content
avatar image
Former Member

Query Stripping in Web Intelligence

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 19, 2011 at 06:44 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 31, 2012 at 10:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 30, 2013 at 01:06 AM

    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

    Add comment
    10|10000 characters needed characters exceeded