Editing Formulas
Opening the Formula panel
Click on the "Formulas" tabulator to open the formula editor.
The editor contains a table with all exiting formulas of the configuration. For each formula there is a number of properties displayed as columns in the table:
- Active: If this property is set to "false", the formulas will be removed from the model and not used. The default value is "true".
- Fact: Use this dropdown box to limit the formula to a single fact. This is normally useful because a formula usually calculates a specific facts and limiting a formula to a fact also increases the speed of a model. But you can also leave this empty entry and calculate every fact with this formula or use the match expression to limit it to more than one fact.
- Match: This boolean expression determines if a formula can be used to calculate a missing coordinate, e.g. by checking the current level of a dimension or anything else. For example, a match-expression "HASLEVEL( Product, 1 )" would only calculate values for the level one of the product dimension. The match expression is optional.
- Expression: This mandatory property determines, how the formula calculates its results. The expression must return "values" (the result must be a sub-type of the type "Value").
Editing Formulas
Creating a new Formula
Use the "Add formula" button to add a new formula to the end of the list. After you created a formula, you can assign it to a fact and change its match-expression and expression by clicking into the table.
If you want to create a formula for a fact which does not exist yet, you can use the "shortcut" button "Add fact" to add a fact to the fact-dimension without opening the dimension editor.
Changing the Formula order
The order of the formulas can be very important, because their match-expressions could overlap and - in that case - the first formulas matching a coordinate will be used by the system.
Use the "Move up" and "Move down" buttons to arrange the formulas after selecting the by clicking on the formula icon in the first column.
Deleting Formulas
Select a formula by clicking on its icon and use the "Delete formula" button to delete it.
