Spreadsheet Add-in User's Guide for Excel

Calculating a Database

Sending updated data to the server does not automatically recalculate the database. If you have the appropriate security privileges to perform database calculations, you can calculate the database from Essbase Spreadsheet Add-in with the Calculation command. For this tutorial, you will not actually calculate the Sample Basic database. For more information on Essbase calculations, see the Database Administrator's Guide.

Caution:
Do not perform any calculation operations for this tutorial.

When you select Essbase > Calculation, Essbase displays the Essbase Calculation dialog box.

Figure 161. Essbase Calculation Dialog Box

The Essbase Calculation dialog box contains the following items:

• The Connection Information text box displays the active database connection.
• The Select Calc Script list box contains the server-based calculation scripts to which you have access.
• The Database State text box indicates the current calculation state of the database. The following states are possible:
  • Calculating--indicates that a calculation is currently running on the database.
  • Data values have been modified since the last calculation--indicates that data values have changed since the database was last calculated. The last calculation may have been an entire calculation of the database or a calculation of any subset of the database.
  • No data values have been changed since the last calculation--indicates that the data in the database has not changed since it was last calculated. The last calculation may have been an entire calculation of the database or a calculation of any subset of the database.

    Caution:
    If the last calculation was performed on a subset of the data, the entire database may not have been calculated since values last changed. To ensure that the results of calculations are up-to-date, you may want to run a calculation of the entire database. For more information, contact the Essbase system administrator.