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

Last updated on MARCH 20, 2017

Applies to:

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

Goal

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

Disclaimer:
-----------------------------------------------------------------------------------------------

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 11.1.1.7.140527; 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:
http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html

 

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

For SampleAppv v406, see:
Script location:
/app/oracle/SAScripts
or
/home/oracle/scripts

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


Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms