We are using cognos for operational reporting out of Manhattan TMS and EEM applications. Over a period data size increased a lot and report performance is very slow. We want to archive the historical data into separate schema in DB, so that reports perform to its best. However business still wants to have reports reading from archived DB.
What is the best approach other organizations are using? Can we put to set of reports one reading from current DB and other from archived DB?
OR is it possible to modify Framework manager model to ingrate two different schemas to pull up the report?
Appreciate any help in this regards
------------------------------
Mona Dhawan
------------------------------