Page 1 of 1

Moving data between 2 cubes with Control Dimensions

Posted: Fri Sep 30, 2011 3:25 pm
by sivan307
Hello:

Is it possible to move data between 2 cubes with different dimensions. and one of the dimension is a control dimension "}Clients. I have written a rule to move data between 2 cubes with different dimensions and the rule compiled. But the data does not load into the target cube.

As an example this is the rule : [] = DB('Rights - OpsPlanTargets','Workflow - OpsPlan','}Clients');

Thanks,
Kal

TM1 Version 9.5.1

Re: Moving data between 2 cubes with Control Dimensions

Posted: Fri Sep 30, 2011 4:15 pm
by qml
sivan307 wrote:Is it possible to move data between 2 cubes with different dimensions.
It is possible, both with rules and TI.
sivan307 wrote:As an example this is the rule : [] => DB('Rights - OpsPlanTargets','Workflow - OpsPlan','}Clients');
Sorry to break it to you, but this is not a rule. What you're showing here is an (incorrect) feeder statement. You need to have a rule (or rules) in your target cube AND a corresponding feeder statement (or statements) in your source cube. You need the feeder only if using skipcheck, but in most cases you should be using it.

Re: Moving data between 2 cubes with Control Dimensions

Posted: Fri Sep 30, 2011 9:05 pm
by sivan307
Extremely sorry for the confusion. I copied the wrong statement. I do have rules( Target) as well as the feeders(Source). Also I follow the Feeder statement rules that start with the SKIPCHECH with rules & FEEDERS with the feeder statement. Thanks for the clarification QML. I have no clue why the data is not being copied. Will look at other options.

Re: Moving data between 2 cubes with Control Dimensions

Posted: Fri Sep 30, 2011 9:45 pm
by qml
You could just share the full code here along with the cubes' dimensionalities and we should be able to help out.
At the very least your feeder statement is wrong as it is trying to feed an almost certainly non-existent element of the }Clients dimension called }Clients.

Re: Moving data between 2 cubes with Control Dimensions

Posted: Sat Oct 01, 2011 11:22 am
by sivan307
Sure, will do that on Monday as I don't have access to the server from home. Thanks for your help anyways..