Bedrock.Cube.Data.Clear

This Bedrock TM1 TI will build a temporary view for a single cube that is to be zeroed out. The temporary view can be restricted by nominating one or more dimensions and elements. Using the filter parameter, nominate the dimension followed by the elements to be included in the temporary subset separated by the Element Delimiter (pElementDelim). If more than one dimension is required, then separate each dimension and element set using the Dimension Delimiter (pDimensionDelim).

The filter can be based on multiple dimensions and multiple views, here are some standard examples using the standard delimiters: 

Filter Tips

Parameters

Parameter

Data Type

Default

Explanation

pCube

String


The cube name where the view is to be created.

pView

String


The name to use for the temporary view subsets created by the process.  If omitted or blank, a view name consisting of a time stamp and random number is used.

pFilter

String


Restrict the portion of the cube to be cleared by entering dimension and element sets. 
   Version : Actual & Year : 2011 & Month + Sep + 2nd QTR

To clear the entire cube use the filter "Clear Cube".

pDimensionDelim

String

&

The delimiter between dimensions.

pElementStartDelim

String

:

The delimiter at the end of the dimension name and the start of the list of elements.

pElementDelim

String

+

The delimiter between elements.

pDeleteTempObj

Boolean

1

Use 0 to retain temporary views and subsets created by the process.

Use 1 to delete temporary views and subsets created by the process.

Use 2 to delete only the temporary views created by the process.

pDebug

Numeric

0

The Debug mode.



Example

ExecuteProcess('Bedrock.Cube.Data.Clear',

    'pCube','General Ledger',

    'pView','',

    'pFilter','Year: 2011 + 2012 & Version: Budget',

    'pDimensionDelim','&',

    'pElementStartDelim',':',

    'pElementDelim','+',

    'pDeleteTempObj',1,

    'pDebug',0

    );


Copyright 2011, bedrocktm1.org Tested on: TM1 Versions 9.1 to 10.2.1 / Cognos Express 9.0 to 10.2