Financial Reporting

Building and Loading Cubes

  1. In the Administration section , click on OLAP Manager in the left pane.
  2. In the Search Bar, enter staging to display only the Staging cubes in the list.
  3. In the right panel, click on and select all the Staging cubes.
  4. In the Action drop-down, select Build.
  5. In the Environments drop-down, select the environment for which you want to build the cubes and click on Confirm.
  6. Remove the word staging from the Search Bar, select the UDM Accounts cube and repeat steps 4 and 5.

Generating Reports

  1. Coming back to SEI, in the Data Models and Views tab, expand the Universal Data Model and Finance folders.
  2. Under the Configuration folder, right-click on the ReportPack France data model and select View Info Pages.
  3. In the Plan Comptable field, enter FRA and click on Générer les rapports.

Setting up the Data Source

  1. In the Administration section, click on OLAP Manager in the left pane.
  2. Select the Finance cube and follow the instructions described in Data Source Editor to edit the DUMMY_Transactions data source.
  3. In the upper-left hand corner, click on Add Calculated Field to add the following fields with these values:
Description Type Type Precision Script
COA String 50 'FRA'
Source ID String 50 'Sage X3'
Global Currency String 50 'EUR'
Ledger Type String 50 '1'
  1. Click on Validate then on Save to add these fields to the list.
  2. You should have a result similar to this:

Mapping the Calculated Fields to the Dimensions

  1. In the Navigation Bar, click on Data Source and select Dimension Mapping to associate Fields with Dimensions.
  2. Once completed, you should have a result similar to this:

Completing Cube Configuration

  1. Back to the DUMMY_Transactions data source, tick the Active checkbox and click on Save.
  2. Go back to the list of cubes.
  3. Build and load the other cubes (all except UDM Accounts and those with the mention staging) as described inBuilding and Loading Cubes.

Testing the Settings

  1. Coming back to SEI, in the Data Models and Views tab, expand the Universal Data Model and Finance folders.
  2. Expand the Finance data model to open one of the views in the ReportPack France folder and use filters.