1. Working with Oracle Smart View for Office
  2. Data and Data Cells
  3. Calculating Data
  4. Changing the Solve Order of a Selected POV

Changing the Solve Order of a Selected POV

Data source types: Oracle Essbase

Using the Cell Information command on the Essbase ribbon, you can view information about a data cell, such as its POV and data consolidation property. Additionally, you can change the solve order of the data cell at the member intersection, or POV, that you selected.

Solve order is a value that represents the order, or priority, of a member when a calculation is performed. Users can view and change the solve order by editing the solve order value in the Data Cell Information dialog box.

The selected data cell must contain a dynamic member in the POV.

To change the solve order of a data cell:

  1. In an ad hoc grid or report, select a data cell.
  2. In the Essbase ribbon, click Cell Information button to view the Data Cell Information dialog box.
    For example, Figure 8-21 shows a simple ad hoc query based on the Sample Basic application and database. We select cell B3, at the intersection of Qtr1 and Profit:

    Figure 8-21 Simple Ad Hoc Grid Based on Sample Basic


    Simple Ad Hoc Grid Based on Sample Basic. Year dimension is on the row axis, Measures dimension is on the column axis. Cell B3, at the intersection of Profit and Qtr1, is selected.

    The Data Cell Information dialog is displayed as follows, showing Qtr1 and Profit as the POV members of this intersection, with the operation calculation type for both set to Dense Consolidation: + (addition). Under Result, a detailed description of the current calculation result is displayed.

    Figure 8-22 Data Cell Information Dialog Box

    Data Cell Information dialog box
  3. Select a member row in the Data Cell Information dialog and click Edit.

    The cursor is placed in the Solve Order field, where you can type a new value.

    Alternatively, double-click the value in the Solve Order field and type a new value.

    Valid solve order values are between 0 and 127.

    If you enter a value above 127, you will be prompted to enter a value between 0 to 127. Note that members with a solve order of zero, 0, will not be listed in the dialog.

  4. Optional: To change the solve order value for any other members in the POV, repeat step 3.
  5. Click OK to commit all solve order changes.
  6. Repeat this procedure to change the solve order of any other data cells.
  7. Run the calculation you require, following the instructions in Calculating Data in Essbase.