Define GL Balance Set OLAP Cube Configuration

Explanation

Use this activity to assign Balance Set IDs to predefined OLAP Cube Measure Names. These are the types of measures that can be used:

• ACT – Actuals
• BUD – Budget
• CFC – Current Forecast
• NFC - Next Forecast

This configuration is used in Finance OLAP Cubes. Note that if more than one company has to be analyzed it is necessary to define the same Balance Set ID in all these companies, since the configuration does not consider company.

Prerequisites

GL Balance Set should be defined.

System Effects

N/A

Window

GL Balance Set OLAP Cube Configuration

Procedure

Use the following procedure to define GL Balance Set Period Configuration.

1. Open GL Balance Set OLAP Cube Configuration window and query for the Measure Group Name.
2. Select the required Balance Set ID, from the List of Values. Note that all the Balance Set IDs in all companies will be displayed. Select only which is required.
3. Save the record.