Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRISOpens in a new window, see the InterSystems IRIS Migration Guide and Migrating to InterSystems IRIS, both available on the WRC Distributions pageOpens in a new window (login required).

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,” earlier in this book.

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":""}
         ]
      }
}
Copy code to clipboard

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 the discussion at the start of this reference.

FeedbackOpens in a new window