25 Examples of Calculation Scripts for Block Storage Databases

These examples of Essbase calculation scripts can help you develop your own calculation scripts. Examples include budgeting, forecasting, cube subsets, allocation, and looping.

• About These Calculation Script Examples

• 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

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