AddInfoCubeRestriction function for IBM Planning Analytics (TM1)

AddInfoCubeRestriction restricts 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

Which TM1 Server version is the AddInfoCubeRestriction function available for?

Version 11

What is the syntax for ExecuteCommand?

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.

Relevant Functions

AddInfoCubeRestriction = Filters InfoCube data as it is pulled into TM1. Use this function to restrict the values that are imported for a specified characteristic
Expand = Expands variable names, enclosed in % signs
FileExists = Searches if a file exists in a folder. If the file exists, then 1 is returned, otherwise 0 is returned
LogOutput = Writes a message to the tm1server.log file
TM1User = Returns the user logged in
WildcardFileSearch = Searches files using wildcard characters in a folder