calculating missed rate

[Former Member]

hello experts,

in my dataflow,we donot get currency rates(e.g,actual 2010,actual 2009,budget 2010,budget 2009,LE....) from source systems(flatfiles)...we calculate them in start routines in dataflow.We generated one report today and one rate is missing and we found out that we havent included this rate in our start routine as this rate has come into picture newly.

our dataflow...

FLATFILE(datasource)->ODS(have one self update transformation)>IC(have one self update transformation)

(ODS isconnected to one Infosource

which is connected back to ODS)

start routine is there between infosource and ODS and start routine calculates all rates.

Now how can we do so we can calculate this rate and make it come appear into our report....preferably without changing start routines...or changing start routines is the only way???.....

Thanks alot....

P Olin

Edited by: polintram on May 25, 2010 4:03 PM

[Former Member · Accepted solution]

Hi,

From what I have understood, the rates are calculated in the start routine and stored in the ODS/DSO. If thats the case, a change in start routine looks the only clean way to accomodate the new rate.

Hope this helps.