IBM Cognos Controller Dimensions

These are the available dimensions used for reports.

Period

Periods to be displayed, also in combination with a selected actuality.

Extra Columns for Period

Period Formula, Period Interval

Period Formula

The relation to the current period. Periods to be displayed:

+0 - shows the values for the period (for example 0207) used as reference
-24 - shows the values for 24 months (for example 0007) before the reference period
N207 - Negative, two years, month seven - shows the values for two years back, month seven (for example 0007), no matter what the current default period is in the year 02xx.
+24 - shows the values for 24 months after the reference period (for example 0407)
P207 - Positive, two years, month seven - shows the values for the year two years ahead, always month seven (for example 0407), no matter what the current default period is in the year 02xx.

Period Interval

Period Intervals to be displayed:

YTD - Year To Date. Cumulative value from the beginning of the year to the reference period.
1 - The value for 1 month. The value for the reference period minus the value for the previous month.
2 - The value for 2 months. The value for the reference period minus the value for the two months prior.
3 - The value for 3 months. The value for the reference period minus the value for the three months prior.
4 - The value for 4 months. The value for the reference period minus the value for the four months prior.
6 - The value for 6 months. The value for the reference period minus the value for the six months prior.
12 - The rolling value for 12 months. The value for the reference period minus the value for the corresponding period the previous year plus the value of the previous year's closing of the books.
NPY - Number of Periods per Year. A rolling value for the number of months that the company has defined, e.g. rolling 12 or 13 months (set in the Maintain/General Configuration window, the General 1 tab).

Actuality

Actualities to be displayed:

AC - Actual
BU - Budget
P1 - Forecast 1
and so on...
$$ - Actuality selected when generating a report.
$F - Forecast actuality selected when generating a report.
Nn - User-defined actuality

Company

Companies to be displayed. $$$$$$ means that company is selected when generating a report.

Extra Columns for Company

Expand One Level, Consolidation Type, Expand to Lowest Level.

Expand Company

If you have selected company as one of the axes, you will also have the possibility to expand groups. You select this check box if the summation structure one level down is to be displayed for the selected group. Only groups can be expanded, not companies.

Consolidation Type

Consolidation types to be displayed. $$ means that consolidation type is selected when generating a report.

Note: The combination of company $$$$$$ and the consolidation type $$ means that the report can apply to all structures.

Group Perspective

Group Perspective to be displayed, i.e. eliminations belonging to a specific group.

Expand All Levels

If you have selected company as one of the axes, you will also have the possibility to expand groups. You select this check box if you want to see the lowest level in the selected group.

Currency Types

Currency types to be displayed:

LC - Local Currency
LE - Group Currency in Legal Structure
$$ - Currency Type selected when generating a report
$M - Multi Company Currency is prompted for when generating a report
Nn - User-defined currency type

Account

Accounts or forms to be displayed, also in combination with a selected movement extension. Forms are entered as #form code. Then all the rows in the form are displayed and you do not need to define each row individually. If there are any changes in the form these changes are also updated here. $A means that account is selected when generating a report. $F means that form is selected when generating a report. At reports generated from Cognos Controller, use the check box next to the account to choose the desired form.

Expand Account

If you have selected a summation account as one of the axis, you will also have the possibility to expand accounts.

If you have selected an account, you select this check box if the summation structure is to be displayed for the account selected.
If you have selected a form, the check box will be automatically selected to show all accounts included in the form.

Extended Dimension 1-4

Extended dimensions 1-4 to be displayed. $$$$ means that extended dimension 1-4 is selected when generating a report. Blank extended dimension 1-4 signifies total.

Expand Dimension 1-4

If you have selected Extended Dimension 1-4 as one of the axes, you will also have the possibility to expand extended dimensions. The expansion will be one level in the dimension structure.

Closing Version/Journal Type

Closing versions/journal types to be displayed. If this is defined, the company and consolidation type must also be entered. Blank journal type signifies reported value. $$$$ means that Closing Version is selected when generating a report. $$ means that Journal Type is selected when generating a report.

Note: If this is defined, the company and consolidation type must also be entered.

Is Closing Version

A check box determines whether closing version or journal type is selected.

Contribution Version/Automatic Journal Type

Contribution versions/automatic journal types to be displayed. Blank automatic journal type signifies base value. $$$$ means that Contribution Version is selected when generating a report. $$ means that Automatic Journal Type is selected when generating a report.

Note: If this is defined, the company and consolidation type must also be entered.

Is Contribution Version

A check box determines whether contribution version or automatic journal type is selected.

Standard Contribution Version

Standard Contribution Version is created with the purpose that, while using one Contribution Version only, you can make reports that at the same time show reported values for the chosen companies and for example Total (Total can be defined by the user) for the chosen groups. For companies, Standard is always Contribution Version BASE. For groups, the user defines the Contribution Version that should be used as Standard. On the menu Maintain/Configuration/Define/Contribution Version/Automatic Journal Types, tab Standard Contribution Version, click on the pop-up menu to select the Contribution Version you want to be selected as Standard.

Movement Extension

Movement extensions to be displayed. $$$ means that movement extension is selected when generating a report.

Counter Company

Counter companies to be displayed.

Expand Counter Company

If you have selected counter company as one of the axes, you will also have the possibility to expand counter company. Counter company can only be expanded with blank counter company. You select this check box in three combinations to display different information:

Counter Company is blank and Expand Counter Company is selected - the rows below display all records with counter companies.
Counter Company is blank and Expand Counter Company is not selected - any values with counter companies are totaled and the total is loaded.
Counter Company is entered and Expand Counter Company is not selected - the specific counter company's value is loaded.

Counter Dimension

Counter dimensions to be displayed. $$$$ means that counter dimension is selected when generating a report.

Note: Only extended dimension 1 is selectable for counter dimension.

Expand Counter Dimension

If you have selected counter dimension as one of the axis, you will also have the possibility to expand counter dimension. You select this check boxes in three combinations to display different information.

Counter Dimension is entered or blank and Expand Counter Dimension is selected - the rows below display all records with counter dimension, expanded one level.
Counter Dimension is blank and Expand Counter Dimension is not selected - any values with counter dimension are totalled and the total is loaded.
Counter Dimension is entered and Expand Counter Dimension is not selected - the specific counter dimension's values is loaded.

Journal Number

Journal number to be displayed (between 0 and 999).

Expand Journal Number

If you have selected journal number as one of the axes, you will also have the possibility to expand journal number. Only blank Journal number can be selected. You select this check box in three combinations to display different information:

Journal Number is blank and Expand Journal Number is selected - the rows below display all records with journal numbers.
Journal number is blank and Expand Journal Number is not selected - any values with journal numbers are totaled and the total is loaded.
Journal Number is entered and Expand Journal Number is not selected - the specific journal number's value is loaded.

Local Text

Will always appear on both axes. Content will depend on what dimensions have been chosen on that axes.

Group Text

Will always appear on both axes. Content will depend on what dimensions have been chosen on that axes.