1-Variables and Prefixes

t

Used to define the table, from which data should be extracted. If table code is C_09.01.a it will look like t: C_09.01.a. The t prefix is mandatory for each variable.

r

Used to define the row or group of rows from which data should be extracted. For example, if row’s number is 0070 then it will look like r: 0070.

c

Used to define the row or group of rows from which data should be extracted. If column code is 0050 it will look like c: 0050.

z

Used to define the row or group of rows from which data should be extracted. If sheet code is 0010 it will look like z: 0010.

m

Used to define the cells from which data should be extracted based on the metric categorization. All cells with provided metrics will be included in the variable.

d

Used to define the cells from which data should be extracted based on the dimension categorization. All cells with provided dimensions will be included in the variable.

ri

Used in cross-report validation, to indicate, that this variable should use data from the referenced module. If reference module is COREP it will be ri: COREP.

dv

Used to define a default value for a variable, that will be used, if no data will be found, in example above, the default value is set to defaultValue. If the default value will not be specified, an evaluation may return no results - in most cases, all facts must have value (from the report itself or the default value); the only function, that is able to handle null values for facts is isNull. Examples of defaultValue are dv: 0, dv:"()"

filter

Used to limit possible fact in the variable. Filter must be a valid test expression based only on the variable, in which it is defined. Any other variable cannot be used in this expression. To indicate current variable value, this function should be used instead of the variable syntax.

seq

Used to define if a variable is a sequence of not. The default value is false. To change the value sequence should be set as true and it will look like seq: true.

id

Used to give a name to the variable. All variables with the same ID are treated as equal, no matter what are the definitions of other prefixes.