Skip to Content
0
Former Member
Jan 13, 2011 at 04:22 PM

history load infocube modelling question

31 Views

hello gurus

i have question and confusion about infocube modelling...

i have data in infocube1 like as follow:

order...itemno.....qty........zdate1

1122.....1...........100.........1/1/2010

1122....2...................100.........1/2/2010

1123....1...................100.........6/1/2010

1123.....2...........100.........1/1/2010

and in ODS1 i have data like

no....zdateods1...........zvalue

1......1/1/2010......aa

2......1/1/2011......ab

3......7/31//2010......0035

4......8/19//2009......5101

5......6/1/2010......abz

so i have to lookup date values from INFOCUBE1 to ODS1 and when Infocube1-zdate1 = ods1-zdateods1

at that time populate the value field in infocube....

so frm help in Forums i was able to write Update Routine and it works fine for all the future records and dataloads

Question is

1...how do i make this work for History data....

2...Data in INFOCUBE1 is stored using Flat file since last 6 months and new file load for every night...

3. does that mean i have to dump all the data and reload all the data again ????

4. i cannot utilize navigation attribute here because the ZValue is random and exist for only certain dates and new values for new dates every year.....