Support Article

Provide option to not include Auto filters in BIX extract 7.1.8

SA-30039

Summary



In Business Intelligence Exchange (BIX) 7.2.2 there is a new feature which will allow the standard filters to be removed from the extraction query.  

There is a secondary option to also remove the order by clause from the query. 


Error Messages



Not applicable


Steps to Reproduce



Not applicable


Root Cause



This issue was determined to be a product enhancement request.
 

Resolution



This feature involves both code and rule changes. Following are the installation instructions:

1. Using Hot Fix Manager install, containing HFix-30131 and its dependent hot fixes.

2. Import HFix-30178.jar using Import Utility.

3. Restart all nodes.

After this when the Extract rule on the "Filter Criteria" tab, user will see a checkbox to "Skip Standard Filters".

With this checked the standard "pzInsKey like" for a classgroup or the "pxObjClass =" for a class will not be included in the generated extraction query.  

There is a second checkbox "Skip standard order by clause".  With this checked the standard order by pzInskey clause to the generated extraction query.

 

Published November 4, 2016 - Updated November 11, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.