key date of a query as a variable filled from the record

Question: The key date of a query, is it for the whole query at once, or could we use it record per record ?

I would like to create a report containing a navigational attribute that is time dependent ;
and I would like to show the status of the attribute based on a date retrieved from the current record.

Example
infoobject...color.....from............to
A...............white....01.01.2000...31.12.2000
A...............yellow..01.01.2001...31.12.2001

"cube"
infoobject....creation date of the record....KYF
A..................02.01.2000.........................5
A.................02.01.2001..........................8

I would like to create a report concerning the color, depending on the creation date
color......KYF
white........5
yellow......8


I am pretty sure this is possible, but I am not sure that I attack the problem from the correct side ?

Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.

Answer:
Yes,
This the same question I have.
Or is this more or less dealing with the "How to...work around the 'Single Key Date' limitation............." Paper?

In fact I want to calculate with a key figure attribute on Material (base-price). This works fine with a replacement path. But the base-price is time dependent and I would use the document creation date.


Thanks!
Copyright ?2007 - 2008 www.jt77.com