/Info/PivotVariables/:cube
Returns information about the pivot variables available to the given cube.
Request Method
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
-
Request Method:
POST
-
Request URL:
https://localhost/api/deepsee/v2/Info/PivotVariables/:holefoods
For comments on the possible forms of the URL, see Introduction to the Business Intelligence REST API.
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.
