Hello Team,
Is is possible to load historical data into a cube by deleting data from that data 1st before putting new data?
Suppose we have the following data for November 16:
Invoice Num: inm123
Transaction DATE: 11/16/2015
Location Country: Germany
Location Center: Mainz
Salesman_Code: empty
Salesman: empty
#Values: 123
One week past and the data updated into:
Invoice Num: inm123Transaction
DATE: 11/16/2015Location
Country: Germany
Location Center: Mainz
Salesman_Code: s123
Salesman: rose
#Values: 123
If this scenario happens again and again due to the data transfer so manually splashing it to zero is not a good idea.
What i want is during cube load if im having a java script that is loading a from a specific date can I delete data for those data then insert the updated value?
Thanks
Rose
Is is possible to load historical data into a cube by deleting data from that data 1st before putting new data?
Suppose we have the following data for November 16:
Invoice Num: inm123
Transaction DATE: 11/16/2015
Location Country: Germany
Location Center: Mainz
Salesman_Code: empty
Salesman: empty
#Values: 123
One week past and the data updated into:
Invoice Num: inm123Transaction
DATE: 11/16/2015Location
Country: Germany
Location Center: Mainz
Salesman_Code: s123
Salesman: rose
#Values: 123
If this scenario happens again and again due to the data transfer so manually splashing it to zero is not a good idea.
What i want is during cube load if im having a java script that is loading a from a specific date can I delete data for those data then insert the updated value?
Thanks
Rose