Query Stripping in Web Intelligence
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
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.