Break back in TM1 at consolidated level

[Nidhi]

Hi ,

I need some guidance. I want to apply break back feature in TM1.
Break-back was one of the famous features in Cognos Enterprise Planning, it allowed data input in a calculated cell and system would adjust all the participating elements to match the new result.

I want to load the data from another cube instead of input at consolidated level but when I try to map or link data to consolidated level, it throws an error. Validation Error : The correspondence is targeting a consolidated member.
Ex- I am considering only single dimension to show the problem.
In Cube 1 Leaf1 , leaf2 , leaf 3

In Cube 2 leaf4 , leaf5 , leaf6 Consolidated1(leaf4+leaf5+leaf6)
Mapping : Leaf1----Consolidated1
Leaf2----Consolidated2

I want to load leaf1, leaf2 data to Consolidated1 which will break back the data to leaf4,5,6 respectively. Is it possible to achieve in TM1?

[declanr]

Most user interfaces do this automatically; there are also spreading options - the one equivalent of "breakback" is proportional spreading in TM1.
In a TI process you just replace cellputn with cellputproportionalspread; be careful with the implementation though as it can accidentally be used at too high a level.

[Nidhi]

Thanks for the reply....
I am using Link in Performance Modeller as 'Rule' ( Implementation type). Since , it throws an validation error link does not get executed as rule.
Can you tell me where I can change in Rule to get it move the data to consolidated level.

[tomok]

You can't do this with rules*, only TI using the CellPutProportinalSpread function.

* Caveat. Of course you can do it with rules, you can do everything with rules. It's just that you would have to write your own break-back functionality, with allocation formulas and all. Not a simple task by any means. You've got to really want it to undertake something that complicated.

[Nidhi]

Thanks for the insight.....

[BariAbdul]

Hi Nidhi,You could also find this thread useful:

http://www.tm1forum.com/viewtopic.php?f ... Rules#p468 Thanks