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.
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.
thanks! is there other way of doing than what is posted in OLAP forum. I tried and it did not work
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.