Define OLAP Cubes

This instruction describes how you define an OLAP cube. The OLAP functionality is an extension to IBM® Controller.

Procedure

  1. On the Transfer menu, click Publish Data and Structures/Define Datamart. The Define Datamart window opens.
  2. Click the New button.
  3. Enter the code and name of the cube in both group and local languages.
  4. If you want to publish data to a datamart that can be accessed through a Framework Manager model, select IBM Cognos BI. For more information, see Publishing to a Datamart Using a Framework Manager Model
    Note: To be able to use the option IBM Cognos BI, you have to log on to Controller with IBM Cognos Authentication. For more information, see IBM Cognos authentication.
  5. If you do not want to use the Default cube type, select Statutory in the Type list box. The Default template will not include group, contribution version, counterpart or transaction currency dimensions. The Statutory template will include the full scope of information entered in Controller.
  6. If you want to include group values in the cube, select the Group option button. Enter the consolidation type, structure version and group you want to create the cube for. Select the Include All Subgroups check box to include all subgroup values in the cube. It is possible to include multiple groups in the selection.
  7. If you want to include company values in the cube, select the Company option button. Enter the company code in the text box or click the Show Valid Choices button to select companies from a list.
  8. If you want to include specific accounts, select the Accounts option button and enter the account code or codes in the text box. You can enter both summation and/or detailed accounts. All detail accounts, which make up the summation account, will be available for drill-downs and exported automatically.
  9. If you want to include accounts from a form, select the Form option button and enter the form code in the text box. Your choice will influence the structure of the cube. An account structure like the form structure in Controller will be created.

    Select the Include Intercompany Details check box if information regarding counter company may be of interest in the cube.

  10. In the Optional Dimensions area, enter specific actualities, currency codes, closing versions, contribution versions and/or extended dimensions to limit the data selection. Use the Period Dimension options to specify settings for time series analysis.

    Depending on the settings in the current actuality, you can group the contents of the export template or cube in time series from weeks up to years, making it possible to drill down through periods. Note that some combinations of frequencies are not allowed, for example four months and quarters.

  11. Select the relevant export option button:
    • Full Export: All data is exported. If old data exists it will be replaced by the new data.
    • Incremental Update: The exported data is appended to the old data. An export template or cube can be constructed with one period at a time.