how to move data from detail cube to consolidated cube in TM1

[Nitin A.]

I will appreciate if somebody can help... I have a detail cube in TM1 where I use product type, gl account as picklist and consolidated cube product type and gl account as dimension. I wanted to move detail cube data to consolidated cube by mapping picklist(product type, gl account) to dimension product type and gl account.  Similar to accumulate dlink in Cognos EP.

[dusherwo]

I don't make a habit of cross referring to other forums, but there is a good thread on this at
http://forums.olapforums.com/viewtopic.php?f=3&t=3985
and the issue comes up frequently.
In my view, the picklist implementation in TM1 is something of a sop to the EP community and hasn't been done very well - people expect it to work like EP and it can't.

[Nitin A.]

thanks!  is there other way of doing than what is posted in OLAP forum.  I tried and it did not work

[dusherwo]

I think you mean "I couldn't get it to work". Both Martin's and Tomok's posts are on point and provide a workable basis to do job.
Don't expect TM1 to work exactly like EP.