UndefVals function for IBM Planning Analytics (TM1)
UndefVals changes the default value for the cube from zero to a special undefined value.
In this video, UndefVals is used to change the default value from zero to undefined value.
Where can the UndefVals function be used?
Rules and TurboIntegrator
Which TM1 Server version is the UndefVals function available for?
Version 11 and 12
What is the syntax for UndefVals?
UndefVals
Relevant Functions
- DB = Retrieve a value from a cube cell
- IsLeaf = Determines if an element is a leaf element or not
- IsUndefinedCellValue = Compares the argument value with the default numeric cube value and returns 1 if the cell value is equal to the cube’s default value
- Undef = Returns the undefined value
- UndefinedCellValue = Returns the default numeric cube value
- UndefVals = Changes the default value for the cube from zero to a special undefined value