We archive 60 months > to data warehouse. Then cognos reports from there.
The read only table - talk with Dba. However, you can use guardium/Sim to watch data changes that are occurring by Dba or etl ... Automated process. Sincerely, D On Feb 1, 2012, at 4:37 AM, Hari Vishwakarma <[email protected]> wrote: > Hi All, > > I have a requirement to set up a Reporting server in remedy. > > As per our process, we need to purge data from Production server after > every 3 months to maintain performance and data storage. > > We need reporting Server only for reporting purpose which will hold > all purged data and real time data from Production. > > Secondly, the reporting server must have read only access to end > users. No one can modify the data from this server. > > Can anybody help me to implement this? > > I need basic steps to setup reporting server which will fulfill above > requirements. > > Best Regards, > > Hari > [email protected] > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
