...
(Revised List – 2014-01-08) Cognos Documentation 1.xlsx
iv. Transformation rules
v. Transformation owner
- Non-dimensional Source Information
- Identification
i. Office
ii. System
iii. Database
iv. Table
v. Column Name
- Descriptive Information
i. Data Type
ii. Length
iii. Precision
iv. Unique
v. Nullable
vi. Domain/Range
vii. Format
viii. Default
- ETL Information
i. Extraction frequency
ii. Extraction criteria
iii. Transformation tool
iv. Transformation rules
v. Transformation owner
...
|
...
- Metadata key
- Descriptive Information
i. Domain
ii. Short Description
iii. Long Description
iv. Data Type
v. Length
vi. Format
- Ownership
i. Owner
ii. Custodian
- Miscellaneous
i. Sensitivity/Security
ii. See Also
iii. Notes
- Dimensional Source Information
- Identification
i. Office
ii. System
iii. Database
iv. Table
v. Column Name
- Descriptive Information
i. Data Type
ii. Length
iii. Precision
iv. Unique
v. Nullable
vi. Domain/Range
vii. Format
viii. Default
- ETL Information
i. Extraction frequency
ii. Extraction criteria
iii. Transformation tool
| a.CognosDataSource | |
| b. CognosDatabase | |
| c. CognosSchema | |
| d. CognosTable | |
| e. CognosColumnName | |
| 2. General Information | |
| a. MetadataKey | |
| i. Domain | |
| ii. ShortDescription | |
| iii. LongDescription | |
| iv. CognosDataType | |
| v. CognosLength | |
| vi. CognosFormat | |
| c. Ownership | |
| i.Owner | |
| ii. Custodian | |
| d. Miscellaneous | |
| i. Sensitivity/Security | |
| ii. SeeAlso | |
| iii. Notes | |
| 3.Dimensional Source Information | |
| a. Identification | |
| i. Dim-Office | |
| ii. Dim-System | |
| iii. Dim-Database | |
| iv. Dim-Table | |
| v. Dim-ColumnName | |
| b. Descriptive Information | |
| i. Dim-DataType | |
| ii. Dim-Length | |
| iii. Dim-Precision | |
| iv. Dim-Unique | |
| v. Dim-Nullable | |
| vi. Dim-Domain/Range | |
| vii. Dim-Format | |
| viii. Dim-Default | |
| c. Dimensional ETL Information | |
| i. Dim-ETL-ExFrequency | |
| ii. Dim-ETL-ExCriteria | |
| iii. Dim-ETL-TrTool | |
| iv. Dim-ETL-TrRules | |
| v. Dim-ETL-TrOwner | |
| |
| .i. NonDim-Office | |
| ii. NonDim-System | |
| iii. NonDim-Database | |
| iv. NonDim-Table | |
| v. NonDim-ColumnName | |
| vi. NonDim-DataType | |
| vii. NonDim-Length | |
| viii. NonDim-Precision | |
| ix. NonDim-Unique | |
| x. NonDim-Nullable | |
| xi. NonDim-Domain/Range | |
| xii. NonDim-Format | |
| xiii. NonDim-Default | |
| xiv. NonDim-ETL-ExFrequency | |
| xv. NonDim-ETL-ExCriteria | |
| xvi. NonDim-ETL-TrTool | |
| xvii. NonDim-ETL-TrRules | |
| xiix. NonDim-ETL-TrOwner | |