Reloading of Inventory Data from ECC using BODS

[Former Member]

Hi

I have been using BODS to load warehouse data from ECC to SQL database and BO reports running top of Stock Universe.

There is mismatch of data from ECC to the values in report.

Can any suggest the best practice  to reload  1 year of data from ECC

Do we need to delete data in SQL data base before deleting ?

What are the pre requisites for reloading ?

Do we need to Include recovery from last execution option in BODS job

Regards,

Nagendra

[Former Member]

Nagendra, it depends on hour your warehouse tables are designed. If that is a table with no history then I would assume you can delete and reload. However, if your warehouse table has history, then you may have to come on an approach!

How are you currently loading data from ECC to warehouse?

Also, how do you know that the report is the exact reflection of the data in warehouse. There maybe universe level/report level filters? Have you verfiied that what report shows is what the table gives too?

Thank You

Ganesh Sampath