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.

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 ​

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".