Lookup link

[flesh2011]

Hi.

New(bie) to Tm1 moddeling and wordering how i can model like a lookup d-link (planning) in Tm1?

Source:
cube Prices:

Contains
Product, time and price

Target cube:
Product element (piclist of Produkt dim)
price element
Time dim

Based on what i choose in piclist of target cube, the correct price should appear.

If there is any better moddeling way to to this, my ears are all open :)

Thanks in advance.


Example picture.....




     

[OLAPBPMguy]

This is a straightforward requirement. In TM1 there are no d-links as such and no real BiFs, calculations and lookups are done with RULES. Your first step should be to read the rules guide.

You should find that the data directory for the rules guide worked examples is included when you install TM1 in the path ...\Cognos\TM1\Custom\TM1Data\Rules_Guide_Data

Rules also need FEEDERS. I won't go into that now, you should read the rules guide and the developers guide to get up to speed. Your rule would look something like this:

Code Select Expand

['Timepris'] = N: DB('PriceCube', !Month, DB('RevenueCube', !Region, !Month, 'Rolle'));