Elimination and matching in Group planning

[marine]

Hi!


I am working on a group planning solution and I am now facing some issues with elimination and intercompany matching. I think I now got the idea of how the eliminations are wanted to be conducted, but I am not sure how to implement the solution technically.

I have read the examples on Group Performance Management from "IBM Cognos TM1 - The Official Guide" and I have built an Elimination cube and 0/1 switches based on organisational levels using the following rules for Elimination cube:


['ToElim'] = IF(ELISANC('ELIM Legal', !ELIM Legal, !ELIM COLegal)=1,0,1);

['Result'] = IF(ELLEV('ELIM COLegal', !ELIM COLegal)=0,['Base']*
(IF(ELISANC('ELIM Legal', !ELIM Legal, !ELIM COLegal)=1, 0, 1)),
CONSOLIDATECHILDREN('ELIM COLegal'));


FEEDERS;
['Base']=>['Result'];


The next step would probably be to implement "Counter party conversion" logic. There are a lot of intercompany transactions and I got a file describing the logic (counterpartcc.PNG) of determining right cost centers. I was planning on creating a mapping cube with this data, since in my fact file, on every row I have information corresponding columns "Cost Center" and Counter Party", and the Counter Party Cost Center is dependent on the combination of the first two columns.The problem is that none of the columns have unique elements, so same cost centers occur several times in both "Cost Center" and "Counter Party Cost Center" columns. "Counter party" is the code for the company that is the counter part in a transaction.

If I have understood correctly, I somehow would need to implement following logic (example from the first row in picture counterpartcc.PNG): if in a fact file "Cost Center"= 1010000 and "Counter Party"=11, then "Counter Party Cost Center"=1190000 etc.

Now my "mapping cube" looks like in Counterpart.PNG, so I only managed to get all codes related to the the first party in a row, apparently because the cost center of the first party is a unique element of the "Company" dimension, even thought it should occur several times. Does someone have experience of this kind of elimination solutions? I hope I could explain my issue clearly enough, since it's quite complex (or then I'm making it more complicated than it really is). Any help would be appreciated!

[paulsimon]

Hi Marine

I have done inter-company eliminations in TM1 before, but I think you are going to need to break down what you are trying to achieve into smaller questions to get a response.

Regards

Paul Simon