Browsing Analysis Services OLAP Cubes with Excel - Microsoft Business Intelligence Tools for Excel Analysts - page 263

Figure 13-22: The Manage Calculations dialog box allows you to create a new calculation, edit an existing calcu-
lation, or delete an existing calculation.

Now you can edit the values in your PivotTable. After you have made your changes, right-click any of
the changed values and select Calculate PivotTable with Change (see Figure 13-23). This forces Excel
to reevaluate all the calculations in the PivotTable based on your edits; including your calculated
members and measures.

Figure 13-23: Select Calculate PivotTable with Change to reevaluate all your calculations.

The edits you make to your PivotTable while in what-if analysis mode are, by default, local edits only.
If you want to actually make the changes on the OLAP server, you have to tell Excel to publish your
changes.

From the Analyze tab choose What-If Analysis ➜ Publish Changes from the OLAP Tools drop-down
menu. This triggers a write back to the OLAP server, meaning the edited values are sent to the source
OLAP cube.

You need adequate server permissions to publish changes to the OLAP server. Your
database administrator can guide you through the process of getting write access to
your OLAP database.

Note