Formulas Table Details

The tool supports the interface of Foresight. Analytics Platform 9 or earlier.

The formulas table includes the following fields:

Field identifier Description
FACT Code of the calculated indicator (FACT TO)
FACF Code of the source indicator (FACT FROM)
OPE Operation code
OPE_RAND Operand
OPE_ORD Operation order
CODT, CODT1, CODT2, ... Output dimensions (destination)
CODF, CODF1, CODF2, ...
CODF_B, CODF1_B, CODF2_B, ...
CODF_C, CODF1_C, CODF2_C, ...
CODF_D, CODF1_D, CODF2_D, ...
...		 Non-binding dimensions of source cubes
 
CUB Source cube
DST Period start date
DFN Period end date

Operation Code:

OPE Description
1 Value
2 Binary
3 Unary
4 Constant
5 Function
6 Delimiter
7 MMin and MMax functions
8 Shift function
9 MAvg function
10 Duplicating functions

Binary Operations:

Operation OPE_RAND

-

 3
+ 4
/ 6
* 7
And 8

Or

 9
> 10
<

11

>=

 12
<= 13
<> 14
== 15

Unary Operations:

Operation OPE_RAND

Not

 2
- 3

Functions:

Function OPE_RAND

lif

 17
Nz 20

Row

 21

Min

 53
Max 54
IsNull 95
Round 81
Trunc 80
Abs 78
Check 88
Exp 91
Ln 92
NoData 93

MMin and MMax Functions:

Function OPE_RAND

MMin

 <0
MMax >=0

Shift function:

Function OPE_RAND

Shift

 -

MAvg Function:

Function OPE_RAND

MAvg

 -

Duplicating Functions:

Function OPE_RAND
DMin 96
DMax 97
Median 98
DSum 99
DCnt 100
DCntD 101
DAvg 102

See also:

Formulas Table