OBIEE - Catalog Manager

Saw Object


The catalog manager is an GUI administration tool to manage the webcat object.

The file catalogmanager.exe is located:

  • on 10g: BI_ORACLE_HOME\web\catalogmanager
  • on 11g, For the first presentation service in the instance (ie coreapplication_obips1 in place of coreapplication_obipsn) :
OS Path
Windows ORACLE_INSTANCE\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalogmanager\runcat.cmd
Linux ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalogmanager/

On 11g, you can:

  • work with the Admin View of the catalog manager of presentation service (in the right frame)

Obiee11g Catalog Admin View

Online / Offline

Many of the operations that you can perform using Catalog Manager are available in both online mode and offline mode. A few operations are available in only one mode or the other. Generally, the operations available in:

  • Online mode are read-only operations and write operations that do not affect the entire catalog, such as setting permissions for an object.
  • Offline mode include most of the operations available in online mode and write functions that affect the entire catalog, such as searching for and replacing catalog text.

The search functionality search in the objects (which is an XML file) of the BI Presentation Service (Folders, Requests, Filters, IBot, Dashboard Prompt, Dashboard Page).

Obiee Catalog Manager Search

The XML object definition doesn't contain the logical SQL but its definition (subject area, table, columns, …). For instance, if you search the term FROM you will never find it.

Export Catalog Information

In online mode:

    -online http://localhost:9704/analytics/saw.dll
    -login Administrator 
    -pwd Administrator
    -cmd report 
    -of c:\output.csv 
    -delimiter \",\"
    -type Requests \”Request Name\” \"Request Criteria Column\"

See OBIEE 11g: Changes to Catalog Manager “Create Report” Command Line Parameters in OBIEE and later


Incompatible value of type enum

Obiee Incompatible Value Of Type Enum

This error indicates a network communication problem during a copy/paste. Just try again and it must succeed.

Documentation / Reference

Discover More
Saw Object
OBI Presentation Service (Webcat) - User

User management for the presentation services (ie the webcat) The “system account” is the user that is used when opening the catalog in offline mode with the catalog manager or runcat (ie local access)...
Obiee Relationships Between Oracle Bi Infrastructure Components
OBIEE - Architecture

The Oracle Business Intelligence components consist of: Oracle Business Intelligence Presentation Services The Oracle Business Intelligence Presentation Services provides the framework and interface...
Obi Edition
OBIEE - Client Tools

Oracle Business Intelligence provides the following client tools, which are supported only on 32-bit Windows operating systems: Oracle Business Intelligence ODBC Driver Oracle Business Intelligence...
Obiee Administration Tools Logon
OBIEE - How to connect remotely to the servers (BI, Presentation) ?

This article shows you how you can perform a remote connections with the OBIEE client tools Administration Tool and catalog manager to manage respectively : the BI Server and the web catalog Variable...
Obiee Webcat Critical Folder
OBIEE 10G/11G - Deployment (Release Promotion) - From Dev, Test to Production

of copy the contents under web\catalog\ Note that the Catalog Manager cmd line version allows specifiying multiple paths, and thus an archive with /system/metadata/ The file root > system...
Obiee Catalog
OBIEE 10G/11G - The (Web|Presentation) Catalog (Webcat)

Old Presentation Catalog... The Oracle BI Presentation Catalog stores BI Presentation Service object such as: answer, dashboard, prompt folders, shortcuts, KPIs, Oracle BI Publisher...
Obiee Caption Prompt
OBIEE 10G/11G - Translate the WebCat (Dashboard, page and report names)

To locate Oracle BI Presentation Catalog Captions (ie dashboard, page and report names (webcat metadata translation), you must : check the custom header checkbox for all column formulas that appears...
Obiee11g Security Overview
OBIEE 11G - Security

Oracle Business Intelligence uses a role-based access control model.Security is defined in terms of Application Roles that are mapped to directory server groups and users. To define a complete security...
Obiee Catalog Manager Preference
OBIPS - Webcat Object Copying and Archiving

All copying a webcat object (Generally an answer or a dashboard) from the same environment or to another. To copy/paste an object, you can perform it in two different operations Archive/Unarchive...

Share this page:
Follow us:
Task Runner