Drop Partition
The MaxL drop partition statement helps you remove a partition definition between two Essbase databases.
To use this statement, Database Manager permission for each cube is required.
Syntax
![Description of drppart.gif follows Description of drppart.gif follows](img/drppart.gif)
Description of the illustration drppart.gif
You can delete partition definitions in the following ways using drop partition.
Keywords
- drop...partition...from
-
Remove a partition definition between the current target cube and a source cube.
- drop...partition...to
-
Remove a partition definition between the current source cube and a target cube.
- at <host-name>
-
Optionally specify the host location, if removing a partition definition associated with a remote instance.
Use the discovery URL to indicate the location. For example,
"https://myEssbase-myDomain.analytics.us2.example.com/essbase/agent"
. - force
-
Specify that the source half of a partition definition should be dropped regardless of whether the target half is missing or invalid. For more information, see Forcing Deletion of Partitions.
Notes
If the create partition statement used was of the format:
create partition SOURCE to TARGET;
Then the only permutations of the drop partition statement that will have effect are:
drop partition SOURCE to TARGET;
drop partition TARGET from SOURCE;
Example
create or replace replicated partition sampeast.east area '@IDESCENDANTS("Eastern Region"), @IDESCENDANTS(Qtr1)' to samppart.company at "https://myEssbase-myDomain.analytics.us2.example.com/essbase/agent";
drop replicated partition Samppart.Company from Sampeast.East;