This content has been marked as final. Show 5 replies
It depends on from which date you are extracting the data.
Ask your client from which year they want to report upon.Ex. from past one year or 2 year etc.I dont think client would be looking for 10 years old data.
BI apps gives you that flexibility that from which date you want to extarct data(Intial extract date you need to set).
Let me know if you need more information.Else please mark helpfull if it helps.
If they want to see 10 years of data then its very difficult for me to tell you how much size is required.
You can do anyone or both of the following
1)Create an SR with Oracle and seek opinion from them on to suggest how much GB is required to store the data
2)Check with DBA's and understand approximately how much GB is required.