CubeGet ​

Retrieves data from a cube based on the intersection of elements.

See FAQ for details about function runtime ordering.

CubeGet(applicationName, cube, ...elementNameN)

CubeGet(applicationName, cube, ...elementNameN)

Parameters ​

• applicationName - The name of the application through which to access the model.
• 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 ​

CubeGet("Performance Management", "General Ledger", "Actual", "2020", "Jan", "Revenue", "Marketing", "Amount")

CubeGet("Performance Management", "General Ledger", "Actual", "2020", "Jan", "Revenue", "Marketing", "Amount")

This will return the value at the provided intersection for the cube "General Ledger".