All examples in this chapter are based on the Sample Basic database.

For examples that use the Intelligent Calculation commands SET UPDATECALC and SET CLEARUPDATESTATUS, see Examples with SET CLEARUPDATESTATUS and Examples and Solutions for Multiple-Pass Calculations.

The information in this chapter applies only to block storage databases and is not relevant to aggregate storage databases.

• Calculate Variance

• Calculate Database Subsets

• Load New Budget Values

• Calculate Product Share and Market Share Values

• Allocate Costs Across Products

• Allocate Values within a Dimension

• Allocate Values Across Multiple Dimensions

• Goal-Seeking Using the LOOP Command

• Forecast Future Values