Using a Clear Cube Job Type

Use the Clear Cube job type to clear specific data within input and reporting cubes.

You can clear the data using member selection or a valid MDX query using member selection. Optionally, you can clear related supporting details, comments, and attachments. You can also elect to do a physical or logical clear of data.

When this job type is executed, it does not delete the application definition in the application’s relational tables. See Clearing Cubes in Administering Planning.

Optional runtime parameters are added as Label and Value pairs (key value pairs) where Label is the name of an attribute, and Value is an assigned value for this attribute.

Clear Cube Job Type parameters include:

Table 12-4 Clear Cube Job Type Parameters

Clear Cube Job Type Parameters	Description
Name	From the Name drop-down, select the name of the cube from which data to clear data. The list of available all clear cubes is based on the selected connection.
Label/Value	Specify optional runtime labels and their values. The optional labels can include : cube members mdxQuery clearSupportingDetails clearComments clearAttachments clearPhysicalOnEssbase To add a new Label/Value pair, click . To delete a Label/Value pair, click .
cube	Specify a valid cube name to clear.
mdxQuery	Valid MDX query. Applicable only for Partial Clear Job, for an ASO cube, defined with MDX query support. Example: "Crossjoin({[Apr],[May],[Jun]},{[Expense1]})"
clearSupportingDetails	Specify if supporting details should be cleared. Allowed values: true or false. Applicable only for Partial Clear Job, for an ASO cube, defined with member selection.
clearComments	Specify if comments should be cleared. Allowed values: true or false. Applicable only for Partial Clear Job, for an ASO cube, defined with member selection.
clearPhysicalOnEssbase	Specify if attachments should be cleared. Allowed values: true or false. Applicable only for Partial Clear Job, for an ASO cube, defined with member selection.

Here are sample job type parameters for a BSO cube:

Here are sample job type parameters for a Clear Cube job type with clear comments parameters:

Here are the sample job type parameters for a Clear Cube job type for a MDX Query parameters:

Here are the sample job type parameters for a Clear Cube job type for a MDX Query parameters: