Generating Cubes

Use Financial Report Cube Generate (25.16.3) to generate data to the reporting tables FRWCubeDim and FRWCubeMeas.

To generate data, select one of the cubes you created during the previous steps. By default, the program generates data for the entire time frame defined in the report calendar of the cube. If the previous years or periods defined in the report calendar for the cube contain data, you can also regenerate a cube from a given start year and period.

By default, Financial Report Cube Generate generates data for all entities defined in the entity list of the cube, but you can also regenerate a cube for a single entity. When you generate the cube, the program displays the number of records read. The fields in Financial Report Cube Generate are almost all read-only.

Select a code for the report cube.

If the cube has not been generated before, its status is Initial. When a cube is generated successfully, its status becomes Operational. The Report Cube daemon processes newly posted GL transactions in any of the source entities and updates the balances in the report cube.

This read-only field displays the defined report chart of the cube.

This read-only field displays the presentation currency for the cube.

Specify the first reporting period for which the program must generate data. The first field contains the year and the second field contains the period.

Specify an entity in this field to generate cube data for this source entity only.

These read-only fields display the start and end dates for the total duration of the cube calendar.

To generate the cube data for revaluations only, select this field. If you select this option, the system does not read balances from the source domains. Instead, it recalculates the PC balances using the latest exchange rates.

The Exchange Rates tab enables you to load and review the rates used for generation.

To generate the financial report cube, click Generate. The cube build can take between a few minutes and an hour, depending on the volume of data in the GL history table (PostingHist) and the number of dimensions the cube contains. The dimensions include the number of entities and analytical dimensions such as sub-account, cost center, project, daybook, currency, and SAFs.

You can view the progress of the build in the Generation Status section of the screen, which refreshes every five seconds. The Cube Status field first displays existing cube data being deleted. Next, the system reads GL history and builds the cube. The field displays the progress of the build and displays a message on successful completion, as displayed in Financial Report Cube Generate.

You can also use the Report Writer Utility program Cube Build Log Browse (25.16.50.1) to monitor the progress of the cube building. Filter on the Cube Code and look for the row displaying Counter in the Error Type column.

Note: Use the browse Auto Go option to automatically refresh the results every n seconds. This facility enables you to see the Counter record updated automatically.