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.....