Skip to Content
Feb 04, 2015 at 10:02 AM

Strategy to handle Historical data in SAP BW


Hello Gurus,

I have a question @ strategy level what is the approach to handle Historical data in SAP BW.

  1. How do we plan to store historical data in BW. For example do we keep 1 year data in each DSO and 10 years in Inforcube?
  2. How do we will achieve the data for more than 3 year?
  3. How easy is to retrieve the data for reporting?

Could you please help me to provide some Best practices and Guidelines what is the approach and steps to be followed ?