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
-
Request Method:
POST
-
Request URL:
http://localhost:52773/api/deepsee/v1/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.