copy data between 2 cubes from consolidated to leaflevel

Post Reply
dilip
Posts: 128
Joined: Thu Dec 15, 2011 8:22 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

copy data between 2 cubes from consolidated to leaflevel

Post by dilip »

Iam novice user in development as I know admin.Please help me if you can help me.

suppose there are 2 cubes cube1 and cube2.I want to move data from any one to other.
I want to create same cube with copy with same number of dimensions and want to move data between them but only change i need to do is that the L1 level element in cube 1 is working as leaf level or 0 level element in cube 2.suppose in 1 dimension I have elements A,B,C,a,b,c and hierarchy as A-level3,B-level2 and C-level1 under C tehre are 3 n-level elements say a,b,c. so C is summation of a+b+c. and in cube 2 same dimension contains the elements as A,B,C A-level2,B-level1,C-nlevel. Now i want to move data from C element of type nlevel of cube2 to C element of type Consolidated level in cube 1 or vice versa...I have to do this using TI process not from rule.How we can achive this?
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: copy data between 2 cubes from consolidated to leaflevel

Post by BariAbdul »

"You Never Fail Until You Stop Trying......"
Post Reply