Add or Update Filter Definitions

To add or update a Filter Definitions in the XLS file, follow these steps:

To add or update a Filter Definitions in the XLS file, you must populate certain mandatory columns in each of the sheets. The details are described in the following:

Note:

The Bulk Upload utility does not support incremental updates of the definitions (Delta updates). The upload deletes the existing Filter Conditions and replaces them with the Filter Conditions present in the XLS file.

Data Element Filter

The columns which can be edited or added in a new row in this sheet are as follows:

• FILTER ID
• TABLE NAME
• COLUMN NAME
• FILTER METHOD (Input 0 for Specific Values or 1 for Range)
• SEQUENCE
• EXCLUDE
• FROM OPERATOR
• FROM VALUE
• TO OPERATOR (in case of ranges Filter Method only)
• TO VALUE (in case of ranges Filter Method only)

Other columns and their values are for reference purposes and they will not affect the Filter Definitions when uploaded back in the OFSAA System.

Hierarchy Filter

The columns which can be edited in an existing row or added in a new row in this sheet are as follows:

• FILTER ID
• MEMBER

Other columns and their values are for reference purposes and they will not affect the Filter Definitions when uploaded back in the OFSAA System.

Attribute Filter

The columns which can be edited in an existing row or added in a new row in this sheet are as follows:

• FILTER ID
• SEQUENCE
• DIMENSION ID
• ATTRIBUTE ID
• ATRRIBUTE VALUE

Other columns and their values are for reference purposes and they will not affect the Filter Definitions when uploaded back in the OFSAA System.