Validating 10g reports for the upgrade to 11g


You must accept the OTN License Agreement to download this software.
Accept License Agreement | Decline License Agreement


OBI 10g webcat check utility for the 11g upgrade - overview

Due to the number of new features in OBIEE 11g compared to 10g, there are potentially some manual modifications of reports required after the upgrade. The objective of this utility is to help assess the volume of manual workload. This utility will read 10g catalog and identify a number of reports that will require manual review/modification after the upgrade. The list of reports is not exhaustive. There are some use cases that cannot be detected this way. But the utility will identify the most common issues.

The package includes a presentation on what the tool checks: 10g11gUpgradeUtility.pptx

This tool is not supported.

Instructions:
Download Download OBIEE10g-WebcatUpgradeCheckv11.zip
- Install a JDK 1.7+
- Unzip the webcat check package
- Change the launching batch with your correct JAVA_HOME and 10g WEBCAT location:

-For windows environments, edit checkWebcat.bat and change the two following variables to valid locations:
SET JAVA_HOME=c:\Oracle\Middleware\Oracle_Home\oracle_common\jdk1.7
SET WEBCAT_LOCATION=.\reports

-For linux, edit checkWebcat.sh and change the two following variables to valid locations:
JAVA_HOME=/oracle/oracle_home/oracle_common/jdk1.7
WEBCAT_LOCATION=./reports
If you edited your .sh on a windows environment, make sure you convert the shell using dos2unix

* Launch checkWebcat.bat or .sh
* Review the logs and csv generated in the logs folder.