Modifying Calculations

  To modify a calculation:

1. Right-click a dimension member header and select Analysis Tools, then, Analysis Tools Manager.

   The Analysis Tools Manager is displayed.

2. Click a calculation definition.

3. Click Edit.

   The Calculation Definition dialog box displays the arguments for the selected calculation definition.

4. Optional: To change the calculation definition name, enter a name in Name.

5. Optional: To move the calculation position, select another option.

6. Optional: If you selected Insert Before or Insert After, select an insertion point from the corresponding list.

   The calculated row or column is inserted before or after the specified dimension header.

7. Optional: To change the calculation type, select a calculation type from Function.

   Changing the calculation type requires that the user to redefine all arguments. For instructions, See To create a calculation:.

8. Optional: To change the arguments for the calculation, perform one:

   • Click an argument, click a dimension member label, and click the arrow button.

   • Click an argument, enter a value in the Constant text box, and click the arrow button.

   • Select Advanced to display dimension member combinations. Click an argument, click a dimension member combination label, and click the arrow button.

     The calculation definition is displayed in the Formula group box.

9. When the calculation is redefined, click Apply and OK.

10. Click Close.