I am new to TM1 for several month,Now,i am in difficulty that TM1 Cube View show result Actual vs Budget , for Actual data in Cube1 and Budget data in Cube2,performance is poor by rule .
scene as:
Cube1 which contains Budget data ,eg,dim1 has two level A--A1 (A1 attribute named proudct ,value=ture)
Cube2 which contains Actual data , eg, dim2 has three level A--A1--A11
show result Actual vs Budget in Cube1 by rule:['actual']=N:IF(ATTRS(‘dim1', !dim1, 'attribute name') @= 'ture', DB('Cube2',!dim2, 'actual'), CONTINUE);
Now I want Copydata actual data ' A1' from Cube2 to Cube1 by TI way,please give me some help,thanks.
CopyData from a Cube to another Cube?
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: CopyData from a Cube to another Cube?
Please use the search feature on this site. There are probably literally dozens of examples already posted.
-
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: CopyData from a Cube to another Cube?
I would also suggest that you take another look at using rules - because I suspect you may be not using skipchecks and feeders. If you aren't then yes, rules will be too slow.
From what you have written (which I didn't find very easy to follow) you are trying to pull high level budget into a cube with more detailed actuals. To do that you need either to rule into a parent level (A1 in your terms), which will bring its own challenges (feeders inter alia) or to create/assign a set of N level lines to hold your budget. Alternatively you could consider bringing the actuals over to the budget cube at a summary level. This would work better, I suggest. Remember that feeders only work at N level so you'd need to build some kind of attribute (don't use elpar, it will break when you change your structure) to link A11 in actuals to A1 in budget.
You can't, of course, use TI to write values against a C level element.
From what you have written (which I didn't find very easy to follow) you are trying to pull high level budget into a cube with more detailed actuals. To do that you need either to rule into a parent level (A1 in your terms), which will bring its own challenges (feeders inter alia) or to create/assign a set of N level lines to hold your budget. Alternatively you could consider bringing the actuals over to the budget cube at a summary level. This would work better, I suggest. Remember that feeders only work at N level so you'd need to build some kind of attribute (don't use elpar, it will break when you change your structure) to link A11 in actuals to A1 in budget.
You can't, of course, use TI to write values against a C level element.