Setting the Solve Order (Hybrid mode only)

To set the Solve Order property:

1. On the Home page, click Application and then Overview.

2. Click Dimensions to open the Simplified Dimension Editor and select a dimension.

   The Edit Member Properties screen for the selected dimension is displayed.

3. Right-click on a header row and uncheck Default Mode.

4. Select the Member Name column, and from the Actions menu, click Freeze to freeze the column and edit the member properties.

5. Select the member for which to modify the solve order.

6. Set the required solve order value in the Consol Solve Order column. You can modify the Solve Order for any of the other cubes in the application, such as CbCR, if required.

7. Save your changes.

8. From Actions, select Refresh Database, and click Refresh.

For more details about the solve order property values, refer to the Oracle Enterprise Performance Management Cloud Operations Guide .

You can also modify the solve order property using the Smart View Add-on for Administrator extension.

To set the Solve Order property using Smart View:

1. Using the Dimensions folder on the Smart View panel, open the dimension for which to modify the solve order.

2. From the Financial Consolidation and Close Ad hoc ribbon, select Member Selection.

3. From Member Properties, select Consol Solve Order, and move it to the column. You can modify the solve order for any of the other cubes in the application, such as CbCR, if required.

4. Specify the dimension member to be modified on the row.

5. Edit the value in the Solve Order column and click Submit Data on the Ad hoc ribbon.

6. Right-click the Dimensions folder on the Smart View panel, and select Refresh Database to initiate a cube refresh.

Note:

This applies only for hybrid optimized applications. See: Optimizing the Application Model for Hybrid Aggregation