Lookup

[pobrouwers]

Hello Everybody.

how do you achieve this by rules in the 2nd Cube ?
In the 2nd cube, 25000 is the sum of line 1 and 3 in the 1st and 4000 is line 2



Thx in advance

[David Usherwood]

I would approach this as follows:

Workings cube dimensioned by
Budget Detail
Categorie Frais
Lignes
and the 'unit' dimension you have on the page

In this cube, a rule on the lines of
[''Montant Detail'] = n:
if(
DB('<source cube>,'Categorie',!Unit,!Lignes) @= !Categorie Frais,
DB('<source cube>,'Montant',!Unit,!Lignes),
#else
0);

Then the total for all !Lignes should be the figure you want. You'll need to get the feeders working too of course.

A comment - I'm inferring from your naming conventions that you are from the EP world. Welcome, and I hope we can help you make the transition. I've worked with both tools and I take the view that they both have their place. We've built an integration module which (mostly seamlessly) links EP published databases to TM1 - it was interesting to do.
Regards
David Usherwood
InfoCat

[Steve Rowe]

As a side point how does the information get into cube 1?

A more traditional approach with this type of relational data would be to process the data into cube 2 using a TI process.

Cheers,

[pobrouwers]

Thank you for your answers
Finally, I've done that ...



David,

Yes we are from EP world. We are currently building process for integration between Analyst/Contributor and TM1. Do you have some example to help us ?
Thank you