TM1 Function for TI, AddInfoCubeRestriction

Restrict values that are imported from an InfoCube data set. Use this function in the Prolog. AddInfoCubeRestriction can be called multiple times to filter more than one characteristic in a process.

What is the AddInfoCubeRestriction function?

Restrict values that are imported from an InfoCube data set. Use this function in the Prolog. AddInfoCubeRestriction can be called multiple times to filter more than one characteristic in a process.

Where can the AddInfoCubeRestriction function be used?

TurboIntegrator

What is the syntax for AddInfoCubeRestriction?

AddInfoCubeRestriction(STRING CharactName, STRING sign,STRING compOperator, STRING lowValue, STRING highValue)

STRING CharactName = technical name of the characteristic to be restricted. Less than or equal to 30 characters.
STRING sign = ‘I’ for inclusive or ‘E’ for exclusive.
STRING compOperator = Comparative Operator.
– EQ = equal
– NE = not equal
– LT = less than
– GT = greater than
– LE = less or equal
– GE = greater or equal
– BT = between
– NB = not between
STRING lowValue = low value for the operator defined before.
STRING highValue = contains the high value for the operator defined before. Only needed for operators BT and NB.