Dimension naming conventions

There are naming conventions used in the transformation.

In the following table, the target is the FAP cubes, and the source is the IBM® Cognos® Controller relational database.

Table 1. Dimension naming conventions
Cube dimension (target) Relational counterpart (source) Monthly cube Consolidated cube Weekly cube
Account Account X X X
Company Company X   X
CompanyGroup Company   X  
<Ext Dim 1> <Ext Dim 1> X X X
<Ext Dim 2> <Ext Dim 2> X X X
<Ext Dim 3> <Ext Dim 3> X X X
<Ext Dim 4> <Ext Dim 4> X X X
ActualityMonthly PerAct X X  
ActualityWeekly PerAct     X
PeriodMonthly PerAct X X  
PeriodWeekly PerAct     X
Currency Currency Code X X X
Transaction Currency Transaction Currency Code X X X
Consolidation Perspective Consolidation Type X X X
Closing Version Manual Journal Type/Closing Version X X X
Contribution Version Automatic Journal Type/Contribution Version X X X
Origin Company Original Company X X X
Counter Company Counter Company X X X
Journal Number Journal Number X X X
Counter Dimension Counter Dimension X X X

Measures:

  • YTD
  • Transaction YTD
  • Monthly
  • Weekly
  • Comment
  • Transaction Comment
  • Comment Count

Amount

Amount in Transaction Currency

Note:
  • Monthly and Weekly measures are calculated through rules. The weekly value is only applicable for the weekly cube.
  • The comment count is calculated as the summary count of all comments in the leafs in the hierarchy.
  • Transaction comment is for IC.
      

The Account and Company dimensions both have a number of attributes. For more information, see Dimension attributes.