Changing the Solve Order of Data Cells

You can view detailed information about a data cell and change its solve order for the selected POV.

Applies to: Oracle Essbase

You can view information about a data cell, such as its POV and consolidation property. You can also view 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. You can view and change the solve order by editing it in the Data Cell Information dialog box. The selected data cell must contain a dynamic member in the POV.

To view data cell information:

1. In an ad hoc grid, select a data cell.
2. From the Essbase ribbon, in the Analysis section, select Cell Information .
3. In the Data Cell Information dialog, view the following information:
   • The member in POV for the selected data cell. If there are multiple POV intersections, then they are listed in separate rows.
   • The current solve order. You can change this to get different results.
   • The operation calculation type. A detailed description of the current calculation result is displayed in the Result section.
4. To change the solve order value for a member in the POV, type a new value in the Solve Order field.

   Note:

   Valid solve order values are between 0 and 127. If you enter a value above 127, you will be prompted with an error message 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.

5. Click OK to commit all solve order changes.