SAP BW Currency Conversion using Time Reference to exact day

Hi all,

we are on BW4HANA, and I have a Open ODS view flowing into a Composite Provider.

There is a query on the CP, and this has a variable for Display Currency which drives what target currency to convert to.

I have created a conversion type with the attached settings;

0CALDAY is a available and populated for each record in the underlying dataset.

And I have added the conversion details to the Key Figure in the Query;

However when the query is executed, it is converting based on the most recent rate and not the rate for the relevant 0CALDAY???

Am I doing something wrong here?

Basically I want to convert all Net Prices on the report based on the rate for the relevant 0CALDAY (which is many different days) and the Target currency entered as a selection variable.

Any help very much appreciated.

Thanks,

Shane.