instantOLAP Online documentation 2.2.7 - Fact-Functions

Fact-Functions

Syntax

<fact-expression> := <fact-name> '(' [ <Key> { ',' <Key> } ')'

Description

For each fact, instantOLAP automatically generates a function which you can use to access the values of this fact from the cubes. Like in the CUBE-function you also can pass keys as arguments to this functions, changing the current filter which is used to access the cubes. Read the documentation of the CUBE-function for a more detailed description.

Examples

Amount()

Amount( NEXT( Time ) )

Using the Web-Frontend
Using the Workbench
Using the Query-Editor
Using the Config-Editor
Query properties
Chart properties
Configuration properties
Expressions
The Type-system
Syntax
Dimensions and selections
Dimension-Levels
Operators
Brackets
Accessing attributes
Accessing variables
Function calls
Level-Functions
Fact-Functions
Constants
Functions
Formats
SQL-Expressions