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 the illustration drppart.gif

• DBS-NAME

• HOST-NAME

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;