Skip to main content

/Info/PivotVariables/:cube

Returns information about the pivot variables available to the given cube.

Request Method

GET or POST

URL Parameters

cube

Required. Logical name of the cube. This name can include slashes; see Use of Slashes in Cube and KPI Names.

Request Body Details

This endpoint ignores the request body.

Example Request

Example Response

{
    "Info": {
        "Error":"",
        "BaseCube":"holefoods"
    },
    "Result": {
        "PivotVariables": [
            {"name":"CommissionPercentage",
             "caption":"Commission Percentage",
             "defValue":"0",
             "context":"literal",
             "desc":""},
            {"name":"Year",
             "caption":"Year",
             "defValue":"NOW",
             "context":"literal",
             "desc":""}
        ]
    }
}

In the response object, the Result property contains a property called PivotVariables, which contains an array of objects, one for each pivot variable.

For information that applies to all response objects, see Notes on the Response Objects.

FeedbackOpens in a new tab