Moving data between 2 cubes with Control Dimensions

Post Reply
sivan307
Posts: 28
Joined: Wed Sep 01, 2010 2:15 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

Moving data between 2 cubes with Control Dimensions

Post 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
Last edited by sivan307 on Sat Oct 01, 2011 11:37 am, edited 1 time in total.
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Moving data between 2 cubes with Control Dimensions

Post 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.
Kamil Arendt
sivan307
Posts: 28
Joined: Wed Sep 01, 2010 2:15 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

Re: Moving data between 2 cubes with Control Dimensions

Post 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.
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Moving data between 2 cubes with Control Dimensions

Post 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.
Kamil Arendt
sivan307
Posts: 28
Joined: Wed Sep 01, 2010 2:15 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

Re: Moving data between 2 cubes with Control Dimensions

Post by sivan307 »

Sure, will do that on Monday as I don't have access to the server from home. Thanks for your help anyways..
Post Reply