CubeGetFirst
CubeGetFirst is run during the initial pass, and can be used when another MODLR instruction relies on a value from a cube that needs to be retrived first. Other than being run during the initial pass CubeGetFirst is functionally identical to CubeGet.
Retrieves data from an intersection of elements from their respective dimensions within the cube.
See FAQ for more details about function runtime ordering.
js
CubeGetFirst(applicationName, cube, ...elementNameN)
CubeGetFirst(applicationName, cube, ...elementNameN)
Parameters
applicationName
- The name of the application to work in.cube
- The identifier of the cube.elementName1
- An element for each dimension within the cube which when used, finds a specific intersection.elementName2
- An element for each dimension within the cube which when used, finds a specific intersection.elementNameN
- An element for each dimension within the cube which when used, finds a specific intersection.(optional)
Example
js
CubeGetFirst("Performance Management", "General Ledger", "Actual", "2020", "Jan", "Revenue", "Marketing", "Amount")
CubeGetFirst("Performance Management", "General Ledger", "Actual", "2020", "Jan", "Revenue", "Marketing", "Amount")
This will return the value at the provided intersection for the cube "General Ledger".