group consolidation OLAP CUBE

Hi,

Please refer to the explanation below.

This activity is used 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 Consolidation OLAP Cubes.

Prerequisites

In order to perform this activity,

• You should log into a master company for group consolidation and
• Consolidation Balance Set should be defined.

Procedure

Use the following Procedure to define Consolidation Balance Set Period Configuration.

1. Open Consolidation 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.
3. Save the record.

I hope this explanation will be helpful to you. :)

Best Regards,

Yoshini

OLAP cubes are typically used for reporting within a PowerBi tool. Here is a summary about the use of it.

 

Perfect thanks this helps

Best Regards

Sophal