Bedrock.Cube.Data.Copy

This Bedrock TM1 TI will copy data within a cube from one element in a dimension to another element in the same dimension.

Limited to a cube with a maximum of 27 dimensions. 

Parameters

Parameter

Data Type

Default

Explanation

pCube

String


The name of the cube where the data exists.

pViewSource

String


The name to use for the temporary source view and subsets created by the process. If the view does not exist on the server, Bedrock.Cube.Data.Copy will create and destroy the view. 

If parameter is blank a Bedrock view name consisting of a time stamp and random number is used.

If the source view exist on the server, Bedrock.Cube.Data.Copy will use this view as the data source.

pViewTarget

String


The name to use for the temporary target view and subsets created by the process.  If this parameter is left blank, a Bedrock view will be created consisting of a time stamp and random number.

If the target view exists and pZeroTarget parameter is 1, then the view will be destroyed and recreated to clear out the data.

pDimension

String


The dimension where the source and target elements exist.

pSourceElement

String


The element in the dimension from which the data is copied.

pTargetElement

String


The element in the dimension where the data is to be copied to.

pSkipRules

Boolean

1

Use 0 to include rule calculated data in the copied data.

Use 1 to exclude rule calculated data from the copied data..

pZeroTarget

Boolean

1

Use 1 to zero out data in the target element before copying the data. 

pZeroSource

Boolean

0

Use 1 to zero out the source element data after it is copied to the target element.

pDeleteTempObj

Numeric

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.Copy',

    'pCube','General Ledger',

    'pViewSource','',

    'pViewTarget','',

    'pDimension','Version',

    'pSourceElement','Budget',

    'pTargetElement','Budget_v2',

    'pSkipRules',0,

    'pZeroTarget',1,

    'pZeroSource',1,

    '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