Skip to main content

POST /Info/PivotVariables/:cube

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

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 service 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