Bedrock.Cube.View.Create

This Bedrock TM1 TI is used to create a view based on a string based filter instead the usual ViewCreate, SubsetCreate & SubsetElementInsert statements. It dramatically simplifies the process of creating views, allowing you to create a simple string and the complexity is done for you. This method is much more readable and reduces the number of lines of code.

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 name of the cube that the view will be created on.

pView

String


The name of the view that will be created, the name will also be used for any subsets that are created.

pFilter

String


The filter to be used to create the view, see the examples above.

pSuppressZero

Numeric

1

Skip zero values.

pSuppressConsol

Numeric

1

Skip consolidated values.

pSuppressRules

Numeric

1

Skip rule derived values.

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 each element.

pDebug

Numeric

0

The debug mode.


Example

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

  'pCube' , 'General Ledger',

  'pView' , 'Archive',

  'pFilter' , 'Year: 2008 + 2009 & Month: Jan + Feb + Mar',

  'pSuppressZero' , 1,

  'pSuppressConsol' , 1,

  'pSuppressRules' , 1,

  'pDimensionDelim' , '&',

  'pElementStartDelim' , ':',

  'pElementDelim' , '+',

  'pDebug' , 0 

  );


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