/Data/GetPivot/:pivotName
Retrieves the definition of the given pivot table.
Request Method
GET
URL Parameters
pivotName
Full name of the pivot table.
Request Body Details
The request body is ignored.
Example Request
-
Request Method:
GET
-
Request URL:
https://localhost/biserver/api/deepsee/v3/research/Data/GetPivot/Use%20in%20Dashboards%2FPatients%20by%20Favorite%20Color.pivot
For comments on the possible forms of the URL, see Introduction to the Business Intelligence REST API.
Example Response
{
"Info": {
"Error": "",
"PivotName": "Use in Dashboards/Patients by Favorite Color.pivot"
},
"Result": {
"mdx": "",
"sqlRestriction": "",
"cellStyle": "",
"columnHeaderStyle": "",
"rowHeaderStyle": "",
"cellWidth": "120",
"cellHeight": "22",
"rowLabelSpan": 1,
"columnLabelSpan": 1,
"showEmptyRows": 0,
"showEmptyColumns": 0,
"cubeName": "Patients",
"caption": "",
"listing": "",
"defaultListing": "",
"listingRows": "",
"showStatus": 1,
"pageSize": "100",
"colorScale": "",
"rowTotals": 1,
"showZebra": 0,
"showRowCaption": 1,
"columnTotals": 0,
"columnTotalAgg": "sum",
"rowTotalAgg": "sum",
"rowTotalSource": "page",
"measureLocation": "columns",
"hideMeasures": 1,
"autoExecute": 1,
"previewMode": 0,
"canDrillDown": 1,
"dataSource": "automatic",
"baseMDX": "SELECT NON EMPTY [Measures].[%COUNT] ON 0,NON EMPTY [ColorD].[H1].[Favorite Color].Members ON 1 FROM [PATIENTS]"
"userMDX": "",
"rowLevels": [
{
"spec": "[ColorD].[H1].[Favorite Color].Members",
"key": "",
"value": "",
"text": "Favorite Color",
"enabled": 1,
"headEnabled": 0,
"headCount": "",
"filterEnabled": 0,
"filterExpression": "",
"orderEnabled": 0,
"orderExpression": "",
"orderDirection": "BDESC",
"aggEnabled": 0,
"aggFunction": "",
"levelCaption": "",
"levelFormat": "",
"levelType": "",
"aggFunctionParm": "",
"drillLevel": "0",
"advanced": 0,
"levelStyle": "",
"levelHeaderStyle": "",
"levelSummary": "",
"suppress8020": 0,
"drilldownSpec": "",
"childLevels": []
}
],
"columnLevels": [
{
"spec": "[Measures].[%COUNT]",
"key": "",
"value": "",
"text": "Patient Count",
"enabled": 1,
"headEnabled": 0,
"headCount": "",
"filterEnabled": 0,
"filterExpression": "",
"orderEnabled": 0,
"orderExpression": "",
"orderDirection": "BDESC",
"aggEnabled": 0,
"aggFunction": "",
"levelCaption": "",
"levelFormat": "",
"levelType": "",
"aggFunctionParm": "",
"drillLevel": "0",
"advanced": 0,
"levelStyle": "",
"levelHeaderStyle": "",
"levelSummary": "",
"suppress8020": 0,
"drilldownSpec": "",
"childLevels": []
}
],
"filters": [],
"listingFilters": [],
"drillLevels": [],
"measures": [],
"listingFields": [],
"formatRules": [],
"calculatedMembers": []
}
}
