/Data/GetPivot/:pivotName
指定されたピボット・テーブルの定義を取得します。
要求のメソッド
GET
URL パラメータ
pivotName
ピボット・テーブルのフルネーム。
要求の本文の詳細
要求の本文は無視されます。
要求の例
-
要求のメソッド ：
GET
-
要求の URL ：
https://localhost/api/deepsee/v3/Data/GetPivot/SampleFolder%2FSamplePivot.pivot
URL の有効な形式に関する説明は、"Business Intelligence REST API の概要" を参照してください。
応答の例
{
"Info": {
"Error": "",
"PivotName": "SampleFolder/SamplePivot.pivot"
},
"Result": {
"mdx": "",
"sqlRestriction": "",
"cellStyle": "",
"columnHeaderStyle": "",
"rowHeaderStyle": "",
"cellWidth": "120",
"cellHeight": "22",
"rowLabelSpan": 1,
"columnLabelSpan": 1,
"showEmptyRows": 0,
"showEmptyColumns": 0,
"cubeName": "HOLEFOODS",
"caption": "",
"listing": "",
"defaultListing": "",
"listingRows": "",
"showStatus": 1,
"pageSize": "100",
"colorScale": "",
"rowTotals": 0,
"showZebra": 0,
"showRowCaption": 1,
"columnTotals": 0,
"columnTotalAgg": "sum",
"rowTotalAgg": "sum",
"rowTotalSource": "page",
"measureLocation": "columns",
"hideMeasures": "1",
"autoExecute": 1,
"previewMode": 0,
"canDrillDown": 1,
"dataSource": "automatic",
"userMDX": "",
"rowLevels": [
{
"spec": "[Discount].[H1].[Discount Type].Members",
"key": "",
"value": "",
"text": "Discount Type",
"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": [
{}
],
"filters": [],
"listingFilters": [],
"drillLevels": [],
"measures": [],
"listingFields": [],
"formatRules": [],
"calculatedMembers": []
}
}
