Clear: Remove Data from a Cube

The clear CLI command for Essbase clears data from a cube. To use this command, you need at least Database Update permission.

Syntax

clear [-verbose] -application appname -db cubename [-option clearOption[-regionspec regionSpec]]

Option	Abbreviation	Description
-verbose	-v	Optional. Show extended descriptions
-application	-a	Application name
-db	-d	Database (cube) name
-option	-O	Optional. Keyword specifying what to clear. Default option, if omitted, is ALL_DATA. The options for block storage cubes are: ALL_DATA—All data, linked objects, and the outline are cleared UPPER_LEVEL—Upper level blocks are cleared NON_INPUT—Non input blocks are cleared The options for aggregate storage cubes are: ALL_DATA—All data, linked objects, and the outline are cleared ALL_AGGREGATIONS —All aggregated data is cleared PARTIAL_DATA —Only specified data region is cleared. Use with -regionspec
-regionspec	-rs	MDX expression specifying the region to clear

Example

esscs clear -a ASOSamp -d Basic -O PARTIAL_DATA -rs "{([Jan],[Sale],[Cash])}" 

You can also clear data using the Load Data option in Cube Designer, Jobs in the Essbase web interface or REST API, or alter database DBS-NAME reset in MaxL.