1. Administration and Configuration Guide
  2. Unified Analytical Metadata Configurations
  3. Data Element Filters Classification

Data Element Filters Classification

This section explains the option to categorize “Filter classification Types” as Classified, UnClassified, or All which can be used to define Data Element filters on Business Metadata Management objects.

To classify the tables available for a Filter in an existing information domain, perform a Model upload (Incremental / Sliced / Complete) to trigger object registration, which in turn will populate all the necessary entries to the registration tables. This is an optional one-time activity required to register all the tables, so that the tables without classification code are also made available in the Data Element filters.

During Model upload, Object Registration is done for all Tables and columns.
  • Tables with the classification code will continue to have entry in REV_TABLE_CLASS_ ASSIGNMENT with the appropriate classification code.
  • Tables without classification code will also have entry in REV_TABLE_CLASS_ ASSIGNMENT with the value as 1000 (UnClassified).

Once tables are registered successfully, you can go to the Filter window to Define Data Element Filters on any tables and columns. Based on the Classification, the appropriate Classification type option has to be selected in the Data Element Selection window to list the tables.

Note the following:

  • If the field value in CLASSIFICATION_FLG column of REV_TABLE_CLASSIFICATION_B table is set to ‘1’, then it is considered as a Classified table.
  • By Default, the classification codes 20, 200, 210, 310, 370, 50, 300, and 500 will have the CLASSIFICATION_FLG set to “1”.
  • The REV_TABLE_CLASSIFICATION_TL table will have an entry TABLE_CLASSIFICATION_CD = “1000”, TABLE_DESCRIPTION = “UnClassified” to identify UnClassified Tables (that is, tables which are not classified in the ERwin through UDP).
  • The category “All” option will select all the tables available in the Infodom, irrespective of whether table is classified or not.

Since the previous option does not check the classification type, even the table which has CLASSIFICATION_FLG = Blank, in the REV_TABLE_CLASSIFICATION_B table will also be listed. These tables will not be displayed under Classified or Unclassified Category.