AddCubeDependency function for IBM Planning Analytics (TM1)
AddCubeDependency establishes cube dependency, triggered by a TurboIntegrator process. This function is a preemptive feature to prevent a potential lock on the TM1 Server during the system’s use, therefore the best time to use this function is when the server starts up. For reference, a lock occurs when cube dependencies are established through a rule, and the TM1 Server initiates a ‘write’ lock that prevents access to cubes until the server understands the dependency between cubes. Head here to learn more about cube dependency.
Learn how to use the AddCubeDependency to establish cube dependency between the General Ledger and dependent cubes.
Where can the AddCubeDependency function be used?
TurboIntegrator
Which TM1 Server version is the AddCubeDependency function available for?
Version 11 and 12
What is the syntax for AddCubeDependency?
AddCubeDependency(‘CubeA’,’CubeB’)
- CubeA = Name of the base cube
- CubeB = Name of the dependent cube.
Here, Cube B relies on a rule that is dependent on Cube A.
Relevant Functions
- AddCubeDependency = Establish cube dependency manually
- CellGetN = Retrieves a numeric value from a cube cell.
- CellGetS = Retrieves a string value from a cube cell.
- CellIncrementN = Increases a numeric value by a value.
- CellIsUpdateable = Checks whether a cube cell can be written to. If the cell can be written to, the function returns 1, otherwise a 0 is returned.
- CellPutProportionalSpread = Proportionally spreads a value to the children of a consolidation.
- CellPutN = Writes a numeric value to a cube cell.
- CellPutS = Writes a string value to a cube cell.
- CubeClearData = clears the entire data for a Cube
- CubeCreate = Creates a cube using the list of specified dimensions
- CubeDestroy = Deletes a Cube from the TM1 Server
- CubeDimensionCountGet = Returns the number of dimensions in a cube
- CubeExists = Used check if a cube exists on the TM1 Server
- CubeGetLogChanges = Determines whether the logging property of a cube is turned on or not
- CubeSaveData = Serialises a cube to disk
- CubeSetConnParams = Sets the connection parameters and encrypt the password for a virtual cube stored in }CubeProperties control cube
- CubeSetLogChanges = Sets the logging property for a cube
- CubeTimeLastUpdated = Returns a serial value which refers to the last time the cube was updated
- CubeUnload = Unloads a cube and its view from the memory