Bedrock.Cube.ViewAndSubsets.Create

This Bedrock TM1 TI builds a view for a single cube, then assigns empty subsets to that view for one or more dimensions. 

Should be used in conjunction with other Bedrock TM1 TI that will define the elements within the subset.

Parameters

Parameter

Data Type

Default

Explanation

pCube

String


The cube name where the view is to be created.

pSuppressZero

Boolean

1

Set whether data points with no data should be suppressed in the view. 

pSuppressConsol

Boolean

1

Set whether the consolidations should be suppressed in the view.

pSuppressRules

Boolean

1

Set whether rule calculated data points should be included in the view.

pDimensions

String


The dimensions of the cube where empty subsets are to be assigned to the view. If the subset exists for the dimension then all the elements assigned to the subset will be cleared.

pDelimiter 

String

&

Used to separate multiple dimensions in the pDimensions parameter.

pView

String


The name of the view to be created for the cube. If the pView parameter is null then the pSubset parameter value is used. If the pSubset parameter is also null then the default view name is “}” and the cube name.

pSubset

String


The name of the subset to be created for each dimension nominated in the pDimensions parameter. If the pSubset parameter is null then the pView parameter value is used. If pView parameter is also null then the default view name is “}” and the cube name.

pDebug

Numeric

0

The Debug mode.


Example

ExecuteProcess('Bedrock.Cube.ViewAndSubset.Create',

    'pCube','General Ledger',

    'pSuppressZero',1,

    'pSuppressConsol',1,

    'pSuppressRules',0,

    'pDimension','Version & Year',

    'pDelimiter','&',

    'pView', 'zTI_Temp View',

    'pSubset','zTI_Temp Subset',

    'pDebug',0

    );


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