Metadata Attributes to Track

(Revised List – 2014-01-08) Cognos Documentation 1.xlsx

1. Cognos Identification
   1. Data Source
   2. Database
   3. Schema
   4. Table
   5. Column Name
   6. General Information
      1. Metadata key
      2. Descriptive Information

                                                               i.      Domain

                                                             ii.      Short Description

                                                            iii.      Long Description

                                                           iv.      Data Type

                                                             v.      Length

                                                           vi.      Format

1. Ownership

                                                               i.      Owner

                                                             ii.      Custodian

1. Miscellaneous

                                                               i.      Sensitivity/Security

                                                             ii.      See Also

                                                            iii.      Notes

1. Dimensional Source Information
   1. Identification

                                                               i.      Office

                                                             ii.      System

                                                            iii.      Database

                                                           iv.      Table

                                                             v.      Column Name

1. Descriptive Information

                                                               i.      Data Type

                                                             ii.      Length

                                                            iii.      Precision

                                                           iv.      Unique

                                                             v.      Nullable

                                                           vi.      Domain/Range

                                                          vii.      Format

                                                        viii.      Default

1. ETL Information

                                                               i.      Extraction frequency

                                                             ii.      Extraction criteria

                                                            iii.      Transformation tool

                                                           iv.      Transformation rules

                                                             v.      Transformation owner

1. Non-dimensional Source Information
   1. Identification

                                                               i.      Office

                                                             ii.      System

                                                            iii.      Database

                                                           iv.      Table

                                                             v.      Column Name

1. Descriptive Information

                                                               i.      Data Type

                                                             ii.      Length

                                                            iii.      Precision

                                                           iv.      Unique

                                                             v.      Nullable

                                                           vi.      Domain/Range

                                                          vii.      Format

                                                        viii.      Default

1. ETL Information

                                                               i.      Extraction frequency

                                                             ii.      Extraction criteria

                                                            iii.      Transformation tool

                                                           iv.      Transformation rules

                                                             v.      Transformation owner