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
Moving data between 2 cubes with Control Dimensions
-
- 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
Last edited by sivan307 on Sat Oct 01, 2011 11:37 am, edited 1 time in total.
- 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
It is possible, both with rules and TI.sivan307 wrote:Is it possible to move data between 2 cubes with different dimensions.
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.sivan307 wrote:As an example this is the rule : [] => DB('Rights - OpsPlanTargets','Workflow - OpsPlan','}Clients');
Kamil Arendt
-
- 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
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.
- 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
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.
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
-
- 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
Sure, will do that on Monday as I don't have access to the server from home. Thanks for your help anyways..