Controlling Calculation Order for Partitions

You must calculate databases in a specific order to ensure that Essbase calculates the required results.

Figure 134, Calculating Partitions illustrates partitions in which you view information from the West, Central, and East databases transparently from the Corporate database:

Figure 134. Calculating Partitions

This image illustrates partitions (West, East, and Central) in the Corporate database.

West, Central, and East contain only actual values. Corporate contains actual and budgeted values. Although you can view West, Central, and East data in the Corporate database, the data exists only in the West, Central, and East databases—it is not duplicated in the Corporate database.

Therefore, when Essbase calculates Corporate, it must take the latest values from West, Central, and East. To obtain the required results, you must calculate West, Central, and East before you calculate Corporate.