TIME

This table describes the dimension:

Values Description
Description Base elements to store entered data in the time dimension are the months 01 to 12.

The month 00 is used to reflect the opening balances of balance sheet accounts.

Months are aggregated as part of two parallel hierarchies.

  • The YTD hierarchy shows single years build up from accumulated quarters and months. The lowest level shows the base months. This aggregation is designed to analyze balance sheet data since opening balance (00) is part of every consolidated level which then gives the accumulated ending balance of the period.
  • The All Years hierarchy shows individual years. This aggregation totals up adding single months and quarters.
Maintenance The structure can be adjusted according to specific needs of the customer. For example, additional years.
Attribute table 1

Attribute field 1: ElemType - Type of element (numeric or string)

Attribute field 2: Name - Short description in (English)

Attribute field 3: OrderPos - Order position for report listing

Attribute field 4: Base Year - Base Year for Cashflow

Maintenance Manually
Attribute table 2

Attribute field 1: English - English Description

Attribute field 2: German - German Description

Attribute field 3: French - French Description

Attribute field 4: Spanish - Spanish Description

Attribute field 5: Italian - Italian Description

Subsets None