Delete Partition
/essbase/rest/v1/applications/{applicationName}/databases/{databaseName}/partitions
Deletes a partition based on the query parameters.
- To delete a transparent or replicated partition, the partition type, source server, source application, and source database are required.
- To delete a federated partition, the partition type, Datasource name, and measures dimension name are required.
Request
-
applicationName(required): string
Application name.
-
databaseName(required): string
Database name.
-
applicationLevelDatasource: boolean
Specify whether the Datasource is defined at the application level.
-
applicationName: string
Partition source application name.
-
databaseName: string
Partition source database name.
-
datasourceName: string
Datasource name.
-
measuresDimensionName: string
Pivot dimension name. Can be Measures dimension, but does not have to be.
-
serverName: string
Partition source server name.
-
type(required): string
Partition type.
Allowed Values:[ "TRANSPARENT", "REPLICATED", "FEDERATED", "LAZY_TRANSPARENT" ]
Response
- application/json
- application/xml
204 Response
OK
Partition deleted successfully.
400 Response
Bad Request
Failed to delete partition.
500 Response
Internal Server Error.
Examples
The following example shows how to delete a partition on the current target cube.
This example uses cURL to access the REST API from a Windows shell script. The calling user's ID and password are variables whose values are set in properties.bat.
Script with cURL Command to Delete a Transparent Partition
In the following REST API example, the target cube, P_Market.Demo, is based on the Essbase gallery sample Demo.Basic. The Market dimension of P_Market.Demo is comprised of transparent partitions to various source cubes (one for each individual market region: Boston, Dallas, Chicago, and 7 other cities).
call properties.bat
curl -X DELETE "https://myserver.example.com/essbase/rest/v1/applications/P_Market/databases/Demo/partitions?type=TRANSPARENT&serverName=https%3A%2F%2Fmyserver.example.com%2Fessbase%2Fagent&applicationName=P_Boston&databaseName=Demo"
-H "accept: application/json"
-u %User%:%Password%