Define Report Cube
In this section, you create parameters for the report cubes. The parameters determine how the consolidated financial data is stored in the reporting tables FRWCubeDim and FRWCubeMeas.
Create Report Cube Parameters
Set up the presentation currency (PC) and the exchange rates to use when converting from base currency or statutory currency to PC. After you have selected the entities in the report chart, you can also define the report calendar and a selection of entities to include in each cube. In Report Cube Create, you refine your earlier selections.
Report Cube Create
Use Report Cube Create (25.16.13.1) to set up report cubes.
Report Cube Create, Header Fields and Tabs
Cube Code
Specify a code for the report cube.
Description
Specify a maximum of 40 characters for the description of the cube.
Status
Specify the cube status. There are five cube statuses:
• Initial
For new cubes, only the Initial status is available.
• Building
• Operational
When you generate the cube data using Report Cube Generate, the system updates the cube status to Operational. The Cube daemon can only update Operational cubes.
• Needs Rebuild
If the cube generation fails or if the cube definition is changed, the cube status is automatically updated to Needs Rebuild. If the cube rebuild is successful, the system changes the cube status back to Operational.
• Inactive
If you no longer need the cube, change its status to Inactive, which means that the cube is retired. You can change the status of inactive cubes back to Needs Rebuild.
The following table provides an overview of the possible status transitions.
Possible Status Transitions
Status | Set Where | Can Go To | Set Where |
Initial | Cube definition (create) | Building | Cube generate (start building) |
Building | Cube generate
(during generations) | Operational
Needs Rebuild
Needs Rebuild
Inactive | Cube generate (successful end)
Cube definition by user or after changing cube parameters
Cube generation (when not successful)
Cube definition (by user) |
Operational | Cube generate | Needs rebuild
Inactive | Daemon (corruption), cube definition (after changing the cube parameters)
Cube definition (by user) |
Needs rebuild | Daemon (corruption)
Cube definition | Building
Inactive | Cube generate (start building)
Cube definition (by user) |
Inactive | Cube definition | Needs rebuild | Cube definition (by user) |
Chart
Specify the report chart to use for the cube. Many report cubes can use the same report chart.
When you are creating a new cube, all tabs remain deactivated until you specify a valid chart code.
If you change the chart code, the system displays a warning and all chart-related data is cleared and re-initialized.
Currency Tab
Report Cube Create, Currency Tab
Presentation Currency
Specify the presentation currency for the cube. You can specify any currency in the system, provided that the required exchange rates are available.
Note: If the presentation currency is different than one of the source currencies, you must specify a currency translation account (CTA) in the cube’s report chart of account.
Exchange Rate Shared Set
Specify the shared set to retrieve the exchange rates from.
Translation Method
Specify whether to use the currency translation methods defined in the cube or the methods defined in the GL.
• Cube Defined
If you use the method defined in the cube (with separate settings for Balance Sheet and Income Statement accounts), you must complete the BS/IS Exchange Rate Type and BS/IS Translation Method fields.
• GL Consolidation Method
If you use the consolidation setup from the GL accounts, the system uses the consolidation settings defined in the GL account of the shared set of the report chart. For more information on consolidation, see
Consolidation. You can also set up the GL account to use different user-defined exchange rates for each entity. For more information on setting up GL account exchange rates, see the section
Currency Tab in
Setting Up General Ledger.
BS Exchange Rate Type
Specify the exchange rate type for Balance Sheet accounts.
BS Translation Method
The currency translation method indicates the exchange rate. You can choose from:
• Period End rate: The system uses the exchange rate at the end of each period and the total balance of the account is translated with that rate. The period end rate is typically applied for Balance Sheet accounts.
• Simple Average rate: All the rates for the period are added together and divided by the number of rates.
• Weighted Average rate: All the rates of the period are multiplied by the number of days they were valid, and then added together and divided by the total number of days in the period. Average rates are typically applied for P&L accounts.
IS Exchange Rate Type
Specify the exchange rate type for the Income Statement.
IS Translation Method
Specify the rate to use. The options are:
• Period-End
• Weighted Average
• Simple Average
Layers Tab
In the Layers tab, specify the layers to include in the cube. You can exclude layers that you do not want to include in the reports; for example, the transient layers used for storing posting templates. You can also create a cube for management reporting that includes management layers and another cube for statutory reporting that only includes the official layer.
Note: You must specify at least one layer for each cube. Otherwise, you cannot save the cube data.
Report Cube Create, Layers Tab
Dimensions Tab
In the Dimensions tab, specify the dimensions to include in the cube.
Report Cube Create, Dimensions Tab
Include Sub Account/Cost Center/Project/SAF/Trans Curr/Daybook Dimension
Select the relevant fields to indicate which dimensions to include in the cube.
Clear the appropriate fields to exclude dimensions that you do not intend to use, which makes the cube smaller and increases reporting speeds.
Report Calendar Tab
Report Cube Create, Report Calendar Tab
First Report Year
Specify the first report year to create in the report calendar.
Start Date/End Date
To identify the total duration of the cube calendar, enter a start date and an end date.
Period Type
Specify the type of period to use. The options are:
• Months.
• Quarters.
• GL Periods: When you choose the GL Periods option, the GL Periods from Domain field becomes active.
GL Periods from Domain
Specify the name of an existing domain to use the domain GL calendar for reporting.
Click Generate Calendar to automatically create the report calendar for the defined periods. After the report periods are generated, you can edit the report period start and end dates in the grid.
Report Cube Create, Report Calendar Tab with Calendar Periods
Start Date/End Date
Review the proposed start and end dates for each report period and modify them, if required. Start and end dates for report years and periods can be different than the GL calendar year or GL period start and end dates.
All report periods must be within a closed series—the first day of each period must be one day later than the end date of the previous period. In addition, the period numbers must be incremental with no gaps. The system validates the report periods when you click the Generate Mappings button in the Periods Mapping tab.
For a new cube or a cube with no data, you can freely add or remove report periods and change the start and end dates of each period. If you modify report periods that are already mapped to GL periods in the Periods Mapping tab, the period mapping is cleared.
Entities Tab
The Entities tab lists the entities that you specified in the report chart. For a new cube, all entities in the report chart are selected by default. Clear the Selected field for the entities that you do not want to include.
When you use Report Cube Modify to modify a cube definition, only the entities that were selected previously are selected. Therefore, if you add an entity to the report chart after the cube was created, the additional entity displays in Report Cube Modify as unselected.
Note: You must specify at least one entity for each cube. Otherwise, you cannot save the cube data.
If you remove an entity, the period mapping for that entity in the Periods Mapping tab is automatically removed. The process of adding an entity does not automatically add the period mapping. You must do this manually in the Periods Mapping tab.
Report Cube Create, Entities Tab
Source Currency BC/SC
For each entity that you select, you can change the starting base currency and the statutory currency (BC/SC).
Selected
Select or clear this field to add entities or to remove entities from the report cube.
Periods Mapping Tab
In the Periods Mapping tab, click Generate Mapping to map the GL calendar to the report calendar for all report periods specified in the Report Calendar tab. The GL periods of the source entities are mapped to report periods. Based on the start and end dates, the system assigns a default mapping proposal. However, you can modify the default mapping. The start and end dates of the GL periods can be different from the start and end dates of the report periods. A GL period cannot be split over multiple report periods.
Each entity GL period that overlaps with a cube report period is listed on the left of the grid and the corresponding report period is listed on the right of the grid. If a GL period overlaps with two report periods, the report period that has the greatest number of overlapping days with the GL period is kept.
You can freely change the report period year and the number assigned by the system for each entity GL period. You can also delete mapping rows. However, for each report period and entity, there must always be at least one period mapping record.
For a cube that has no data associated with it, click the Generate Mapping button to clear the original mapping data and to generate new mappings. When a cube has associated data, you can only add new report periods; you cannot modify the existing periods. In this case, the Generate Mapping button does not clear the old mapping records. It only appends new mapping records at the end of the mapping. You can only modify these newly added records. When you click the Generate Mappings button again, the newly added records are cleared and replaced by new default period records.
Report Cube Create, Periods Mapping Tab
Deleting Cube Data and Cube Definitions
Use Report Cube Delete (25.16.13.4) to delete report cube data, including the report cube definition. If you want to delete the cube data only and not the report cube definition, use Report Cube Empty (25.16.13.5).
When you open Report Cube Delete, you must first select the cube to delete from the browse. Double-click the cube definition and it opens in Report Cube Delete. When you click the Delete button, a warning message displays.
Modifying Report Cubes
For an operational cube, most of the report cube definition fields are read only in Report Cube Modify; you can only modify the cube status and the report calendar end date. You can also add entities.
If you add a new entity or if you extend the report calendar dates, you must run Report Cube Generate to update the cube with the new entity or report periods. You can run Report Cube Generate selectively for a single entity.
If you need to modify other fields in the report cube definition, use Report Cube Empty (25.16.13.5) to delete the report cube data. You can then modify the cube data in Report Cube Modify. See
Deleting Cube Data.
Deleting Cube Data
Use Report Cube Empty to delete report cube data, but not the report cube definition.
When you open Report Cube Empty, you must first select the cube for which you want to delete data from the browse. Double-click the cube and it opens in Report Cube Empty.
Click the Empty button to delete the report cube data. After you click the Empty button, the cube data is cleared and the cube definition remains. The report cube status is set to Needs Rebuild. You can then modify the cube data in Report Cube Modify.
