Hi Sunil,
Regarding question #2, there are a couple of reasons why this behavior would occur and much of them depending on the version of OnCommand Insight you upgraded from.
In your statement " In DWH reporting, default report and dashboard folders under capacity->storage capacity are missing" I assume you are missing modified or custom reports that were saved in the default reports and dashboards folders.
I will try to provide you a summary of what is backed up depending on OCI version.
- If the upgrade was performed on OnCommand Insight version 6.3.1 or 6.3.2 then that would be an expected behavior.
- In 6.3.1 and 6.3.2, the folders that are captured as part of the backup process are the "Customer Reports" and "Customer Dashboard" folders ONLY.
- As of 6.4.0 >, All "out of the Box (OOO)" folders including; My Folders, Reports, Dashboards, Customer Reports and Customer Dashboards are captured in the Cognos backup process.
- If any of the default reports (e.g OOO canned reports) are modified, they should be saved as a different report name and to a different location rather than overwriting/replacing the default reports that ships with the product. The modified report will be replaced with the factory default reports during the upgrade.
There is a best practice recommendation of backing up not only any modified reports but also making backups of the DAILYBACKUP.zip file located at C:\Program Files\SANscreen\cognos\c10_64\deployment\DailyBackup.zip
See the following document link on saving a modified report. http://live.netapp.com/docs/DOC-30904
lastly, If the end user has a copy of the DailyBackup.zip file and depending on the version of OCI that was upgraded, there may be a chance the "lost' reports are still available in the DailyBackup.zip file and that zip file can be restored to a different OCI client and saved. ** The DailyBackup are overwritten every day.
I hope the above mentioned was helpful.
Don Bourque
OCI Strategy and Architecture
NetApp