Technical data

Creating Rules, Formul as, and User Functions Chapter 10

• Maximum change in values: When the analytic calculation engine has calculated the cells within the c ircular

system for the specified maximum number of times, the circular system is considered to be resolved.

Example of Res

olving a Circular System

In this example, an analytic model contains the following formulas (for simplicity, assume that each data

cube contains only a single cell):

• Formula for BONUS data cube

BONUS_PERCENTAGE * NET_INCOME

•FormulaforEX

PENSE data cube

SALARY + BONUS

• Formula for NET_INCOME data cube

INCOME - EXPENSE

First, the analytic calculation engine determines that this is an indirect circular formula because the data cubes’

formulas refer indirectly to those same data cubes.

Next, the anal

ytic calculation engine analyzes the calculation conditions of the cells within this indirect circular

formula and de

termines that these cells create a circular system. This is because the cells within this formula

are dependen

t on the same values of those same cells.

Assuming that the value for the BONUS_PERCENTAGE cell = 5, the value for the INCOME cell = 10,000,

and the value for the SALARY cell = 6,000, then the circular system is resolved when the analytic calculation

engine iterates until it returns these solutions:

• Cell for BONUS = 190.48.

• Cell EXPENSE = 6,190.48.

• Cell for NET_INCOME = 3,809.52.

If you plug th

ese values into the preceding formulas, each formulaistrue:theleftsideoftheformulais(almost)

equal to the r

ight side of the formula. Once this occurs, the circular system is considered to be resolved.

Changing Circular Formula and Circular System Options

Select the an

alytic model in the part browser.