A database contains two types of values:
Values that you enter, called input data
Values that are calculated from input data
You enter regional sales figures for a variety of products. You calculate the total sales for each.
You enter the budget and actual values for the cost of goods sold for several products in several regions. You calculate the variance between budget and actual values for each product in each region.
The database contains regional sales figures and prices for all products. You calculate what happens to total profit if you increase the price of one product in one region by 5%.
Small differences in the precision of cell values may occur between calculations run on different platforms, due to operating system math library differences.
Essbase offers two methods for calculating a database:
The method that you choose depends on the type of calculation that you want to perform.