instantOLAP Online documentation 2.2.7 - Priority

Priority

Type

Constant Integer

Since

2.2

Description

The priority of the formulas determines their execution order. The system will perform all calculations of the formulas with the lowest priority (e.g "0") first, then all calculations of the second lowest and so on.

The priority of a formula is something different than their position in the formula list, because its position decides if a formula is used (the system searches from top to bottom in the list until the first formula matches) but not about its execution order.

Usually you won't need this property becase the System automatically orders the execution of the formula in the best order, beginning with the values which do not depend on any calculation and ending with the formulas depending on the most other calculations. But whenever you design recursive calculations, the order of the calculations can be important.

Examples

Priority = "4"

Using the Web-Frontend
Using the Workbench
Using the Query-Editor
Using the Config-Editor
Query properties
Chart properties
Configuration properties
Configuration
Database
Table
Column
Alias
Link
Link-Expression
Table-Expression
CSV-Source
CSV-Column
XMLA-Source
Dimension
Grant
Key
Key-Attribute
SQL-Keyloader
SQL-Attribute
CSV-Keyloader
CSV-Attribute
Time-Keyloader
Time-Attribute
XMLA-Keyloader
XMLA-Attribute
Number-Keyloader
SQL-Cube
SQL-Fact
SQL-Dimension
CSV-Cube
CSV-Fact
CSV-Dimension
XMLA-Cube
XMLA-Fact
XMLA-Dimension
Formula
Active
Expression
Fact
Match
Priority
File-Cache
File-Store
Include
Expressions
Formats
SQL-Expressions