/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
-
Request Method:
POST
-
Request URL:
https://localhost/api/deepsee/v3/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.
