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:
- In an ad hoc grid or report, select a data cell.
- In the Essbase ribbon, click 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
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
- 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
If you enter a value above 127, you will be prompted to enter a value between
127. Note that members with a solve order of zero,
0, will not be listed in the dialog.
- Optional: To change the solve order value for any other members in the POV, repeat step 3.
- Click OK to commit all solve order changes.
- Repeat this procedure to change the solve order of any other data cells.
- Run the calculation you require, following the instructions in Calculating Data in Essbase.