...
(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 |