Bedrock.Cube.Clone

This Bedrock TM1 TI will clone an existing cube. The dimensional structure of the cube is copied to the clone cube. Data and/or rule calculated data point in the existing cube can be copied to the cloned cube. If a existing view is nominated only the data in the view will be copied to the cloned cube. If no view is nominated the entire cube is copied. 

Limited to a cube with a maximum of 27 dimensions.

Parameters

Parameter

Data Type

Default

Explanation

pSourceCube

String


The original cube name that is to be cloned.

pTargetCube

String


The name of the clone cube. If this parameter is blank the default clone cube name is the source cube name suffixed with '_Clone'.

pIncludeRules

Boolean

1

Clone the rules from the original cube to the clone cube. 

The clone process does not change the rules from the original cube. The clone rules should be reviewed to ensure cube references are correct after cloning.

pIncludeData

Boolean

0

Clone the data from the source cube.

pSourceView

String


The name of an existing view in the source cube. This view will be used to restrict the amount of data copied from the original cube. If this parameter is null then all the data in the cube will be copied.

pRuleValues

Boolean

1

Use 1 to exclude rule calculated data. Use 0 to include rule calculated data. This value is set to 1 if the original cube rules are cloned as per the pIncludeRules parameter. 

pDebug

Numeric

0

The Debug mode.


Example

ExecuteProcess('Bedrock.Cube.Clone',

    'pSourceCube','General Ledger',

    'pTargetCube','General Ledger Cube Clone',

    'pIncludeRules',1,

    'pIncludeData',1,

    'pSourceView','2011 Actual Data',

    'pRuleValues',1,

    'pDebug',0

    );


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