Dimension attributes
This appendix contains additional information
about some of the dimensions and their attributes. An OLAP database
does not work in the same way as a relational database, for example,
there is no schema or referential integrity.
However, some FAP dimensions have quite a few TM1® attributes. These attributes can be useful in various reporting scenarios as well as in TM1 scripts.
| Company | Description |
|---|---|
| <language>_short | Short name in group language, <language> subject to set-up, for example, EN. |
| <language>_long | Long name in group language. |
| < language>_short | Short name in an additional language. Could be more than one additional (local) language. |
| < language>_long | Long name in an additional languages. |
| Structure Version | Period for the structure version, for example, 200911. Only on groups (aggregation nodes). |
| Consolidation Type | Consolidation type for the hierarchy, for example, CT LE. Only on groups (aggregation nodes). |
| Company Type | Company type as defined for the company in Controller. |
| Country Code | Country code as defined in IBM® Cognos® Controller. |
| Local Currency | Local currency as defined in IBM Cognos Controller. |
| Info 1 - Info 20 | Info fields as defined in IBM Cognos Controller (additional company information) |
| Account | Description |
|---|---|
| <language>_short | Short name in group language, <language> subject to set-up, for example, EN. |
| <language>_long | Long name in group language. |
| < language>_short | Short name in an additional language. Could be more than one additional (local) language. |
| < language>_long | Long name in an additional language. |
| Account Type | Account type as defined for the account in IBM Cognos Controller. |