Uncategorized

Obiee 12c Baseline Validation Tool

The 12c baseline validation tool is useful for comparing dashboards once migrated from 11g to 12c.

The BVT tool is distributed in the OBIEE 12c Client tools.  It can be found @ your obiee 12c client tools directory i.e. C:\obiee12c\bi\components\oracle.bi.bvt

Runtime :-

cd C:\obiee12c\bi\components\oracle.bi.bvt\OracleBI-BVT

bin\obibvt -config testconfig.xml -deployment PreUpgrade

The testconfig.xml file is configurable, you can setup the “source” and “target” environments, and which dashboards to test. You can define the Analytics URL and weblogic connection details in the “deployment names” i.e. source / target environments i.e. edit the “Deployment section ”

<AnalyticsURL>https://192.168.56.101:7781/analytics</AnalyticsURL>
<XmlpURL></XmlpURL>
<UserName>weblogic</UserName>
<Password>Admin123</Password>
<IgnoreSSLCertErrors>false</IgnoreSSLCertErrors>

Include Dashboards in the <Tests> tags. Essentially where-ever it states “CatalogRoot” define the area of the webcat you want to test i.e.

<Test name=”GetCatalogTest” enabled=”true”>
<Parameter name=”CatalogRoot” value=”/shared/01. QuickStart/_portal/1.00 General Index”/>
</Test>

<Tests>
<!– CAUTION: The CatalogRoot Value for BIP Plugin is different than other plugins–>
<!– For BIP remove the virtual paths where the other plugins use physical paths–>
<!– To get the physical path of an item, in the Oracle Anwsers catalog, right click the item and select “Properties”–>
<!– Ex: For BIP : “/Sample Lite/Published Reporting”–>
<!– Ex: For others: “/shared/Sample Lite/Published Reporting”–>
<TestPlugin name=”com.oracle.biee.bvt.plugin.catalog” enabled=”true”>
<Test name=”GetCatalogTest” enabled=”true”>
<Parameter name=”CatalogRoot” value=”/”/>
</Test>

Run again passing in the Target environment to test i.e.

bin\obibvt -config testconfig.xml -deployment PostUpgrade

Once run this will create a folder for each environment within the BVT directory. You can then run the compare utility

bin\obibvt -compareresults Results\PreUpgrade Results\PostUpgrade -config TestConfig.xml

You can then navigate to the Comparisons results folder i.e. C:\obiee12c\bi\components\oracle.bi.bvt\OracleBI-BVT\Comparisons\PreUpgrade_PostUpgrade

You can view the HTML report, which will give you a good idea of issues between the environments…

Reference

http://allthingsorcl.blogspot.co.uk/

Leave a Reply

Your email address will not be published. Required fields are marked *