Skip to Content

Query stripping is available for relational universes as well as OLAP universes. (4.1 and Up) including universes on SAP HANA. Query stripping is used to optimize performance by automatically rewriting the query to retrieve only objects included in the report.  This feature is available in Web Intelligence.  For relational universes, you need to activate the option to allow query stripping in the business layer properties in the information design tool. This option is not selected by default for relational universes whereas for OLAP universes, it is active by default.

Query Stripping Business Layer.GIF

Once you update Business Layer Query Option to Allow query stripping The “Enable query stripping “  option is selected in the document properties and data provider  in Web Intelligence by default.

Document Properties

Query_Stripping Document Property.jpg

Query Properties

Query Stripping Query Property.jpg

Important Note : Please make sure Query stripping is enabled at all 3 levels (Business layer , Document Property and Query Property).  If you don’t enabled it in all 3 level you will not see benefits of Query Stripping.

Pros and Cons Using Query Stripping:

Pros: Query performance is very good as query retrieves only objects included in the report.

Cons: Unused objects gives #refresh error when these objects are drag and dropped on report.

Conclusion: Considering cons, we will have to use it sparingly. Users don’t likes to see #refresh error. But for ad-hoc reports, will be nice to have.



To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply