DB function for IBM Planning Analytics (TM1)
DB retrieve a value from a cube cell.
In this video, DB is used to multiply the Sales Quota Budget values from January by the Monthly Growth in the Sales Assumption cube.
Where can the DB function be used?
Rules
Which TM1 Server version is the DB function available for?
Version 11 and 12
What is the syntax for DB?
DB(Cube, e1, e2 [,…en])
- Cube = Cube Name to retrieve the data from
- e1,e2….en = Dimension element names determining the data point within the cube to be retrieved. The sequence of the element arguments should match the order of the dimensions in the cube.
Note:
The principal element name or Alias can be used to argue the function. If using hierarchies, the dimension name should be mentioned along with the element name, like HierarchyName:ElementName
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