My Oracle Support Banner

OBIEE 11g: Web Catalog Utilities: Analysis, Error Checker, Reference Checker and ACL Permissions Dump (Doc ID 1934552.1)

Last updated on AUGUST 15, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Business Intelligence Suite Enterprise Edition - Version and later
Oracle Business Intelligence Enterprise Edition - Version N/A and later
Information in this document applies to any platform.


The goal of this document is to show the Web Catalog Utilities available in the Sample App demo.


The SampleApp contents and its code, including but not limited to, any custom Java programs,JavaScript, SQL, SQL Loader Scripts, Shell Scripts, R Scripts and reports, are distributed free for demonstrative purposes only. It is neither maintained nor supported by Oracle as a licensed product. We specifically do not guarantee the accuracy of the results produced by any of these custom utilities. You must accept and comply with OTN License Agreement to use OBI EE SampleApp.

Further, these scripts are only tested with version of SampleApp that they are released with.

For example: SampleApp v406 is distributed with; therefore, the utilities are only tested against this specific release an no others.  There could be changes/difference in the API with earlier or subsequent releases.

For more details and to obtain the latest Sample Application virtual machine,  refer to the Sample App Virtual Machine available to be downloaded from the Oracle Technology Network:


Note: All scripts referenced in the examples are from the Sample App Virtual Machine version 305.

For SampleAppv v406, see:
Script location:

For convienence, they are also attached here: v406  ( comressed with 7-zip/.7z )


Dashboards and Analysis:

10.31 Webcat Analysis:
Columns to Analysis, Dashboard Orphans, Full Orphans, Overview, Dormant Objects, Dashboards Index, Aggregated Index, Dashboards to Analysis, Analysis to Dashboards, Analysis to Columns

10.32 Webcat Permissions:
Accounts Allowed Object Access, Accounts Denied Object Access, What Objects are Denied to an Account, What Objects are Allowed to an Account, Detailed Permissions List

10.40 Webcat References Checker:
Readme First, Reference Search Overview, References Details, Top Target Types, Top Broken References, Targets Referenced by an Object, Objects Referencing a Target

10.41 Webcat Errors Checker:
Bad Syntax Reports Overview, Bad Syntax Details, Reports with Execution issues Overview, Execution Errors Details


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Web Catalog Analysis
 Web Catalog Error Checker
 Web Catalog Reference Checker
 Web Catalog ACL Permissions Dump

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.