TM1 Forum

Hello,
I am using TM1 9.5.1

I am attempting to import consolidated elements from one TM1 Cube as n level elements into another cube.

Thus far I am not having much success, I can successfully import the elements if I adjust the cube view from the source cube to the N elements but the once I consolidate on one dimension for some reason no data pulls across to the target cube.
I am hoping that I am missing something simple.


Thanks in Advance

Chris

Cube A (Source Cube)
Version
Type
Cost Center
Accounts
Periods
Measures


Cube B (Target)
Cost Center
Accounts
Periods
V Measures


Info on Data Leaf:

V_Measure='D_YTD';
V_Acct='Sales';
if (VALUE_IS_STRING=1, CellPutS(SVALUE,'P_Plan',CostCenters,Periods,V_Acct,V_Measure), CellPutN(NVALUE, 'P_Plan', CostCenters,Periods,V_Acct,V_Measure));

More than likely your source view is set up to skip calculated values. Thus if any dimension in the view contains all C elements then you will get no records.

However in this case you are much better off to process from leaf level to leaf level as although this could likely process many more records it will do so with much better performance than processing consolidations. However to do this you will need to do 2 things:
- accumulate values in the process
- create a mapping attribute in the source (more detailed) dimension which specifies the element to accumulate to in the target dimension

There's probably a 3rd thing which you need to do as well which is to ditch the wizard code and write the code yourself as at about this level of complexity (which isn't that great) the wizard becomes useless.

I recommend driving your C level value(s) into N level elements with a set of rules and feeders, then turning suppress 'calculated' (ie consolidated) on. If you don't you'll be processing lots more data than you want.