1. Analytical Application Infrastructure User Guide
  2. Unified Analytical Metadata
  3. Filter
  4. Download Filter Data, Bulk Edit, and Upload
  5. Edit the XLS File

Edit the XLS File

The downloaded XLS file contains the Filter Definition Records with the following sheets in it:

  • SNAPSHOT: This sheet contains a summary of the Filters Definitions of the XLS file and provides information about the User who downloaded the file and the timestamp details of when the file was downloaded.
  • DATA ELEMENT FILTER: This sheet contains details of all the Data Element Filters that were selected for the download.
  • HIERARCHY FILTER: This sheet contains details of all the Hierarchy Filters selected for the download.
  • ATTRIBUTE FILTER: This sheet contains details of all the Attribute Filters selected for the download.

    A Filter Definition may contain multiple rows to cover all of the filter attributes.

  • REFERENCES: This sheet contains information for valid values that you can refer to when modifying the DATA ELEMENT FILTER, HIERARCHY FILTER, and ATTRIBUTE FILTER Sheets.

You can modify the Filter Definitions by the following actions:

  • Add a new row to add a new Filter Condition.
  • Delete a row to remove a Filter Condition.
  • Modify a row to update an existing Filter Condition.