Bedrock.Cube.ViewAndSubsets.Delete

This Bedrock TM1 TI deletes a view and any specified subsets that are attached to the dimensions of the cube. It is used in clean up after Bedrock.Cube.View.Create is used. The process first deletes the view on the cube if it exists and then loops through each dimension on the cube and deletes subsets on those dimensions with the name provided.

Parameters

Parameter

Data Type

Default

Explanation

pCube

String


The name of the cube that the view will be deleted from.

pView

String


The name of the view that will deleted by executing the process.

pSubset

String


The name of the subset(s) that will be deleted by executing the process.  If the parameter is blank, any subset(s) named the same as the view will be deleted. 

pMode

Numeric

1

Use 0 to retain view and subset(s).

Use 1 to delete view and subset(s).

Use 2 to delete only the view.

pDebug

Numeric

0

The debug mode.


Example

ExecuteProcess('Bedrock.Cube.ViewAndSubsets.Delete',

    'pCube','General Ledger',

    'pView','Archive',

    'pSubset','ArchiveSub',

    'pMode',1,

    'pDebug',0

    );


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