The Web Catalog becomes in 11g the Presentation Catalog. Be careful not to confuse with the Old Presentation Catalog term of the Presentation Layer from the repository in 10g …
The Oracle BI Presentation Catalog stores BI Presentation Service object such as:
KPIs,
Oracle BI Publisher objects (such as reports and templates).
in a directory structure of individual files.
This object are generally created with the BI Presentation Services Dashboard.
Each object is composed of two files:
The attributes file contains:
To access an object in the catalog, users must have appropriate ACL entries for that object. All objects in the catalog use ACL entries.
In 11g, the Everyone group has been replaced with the AuthenticatedUser role
When opening a webcatalog, you will always find the following folders
from 11.9:
/users/<user>/_delivers
/users/<user>/_portal
/users/<user>/_filters
/users/<user>/_selections
/users/<user>/_savedcolumns
/users/<user>/_thumbnails
/users/<user>/_internals
A way to classify queries used in an analytic application is to group them according to their function:
It makes sense to structure the web catalog to reflect these five classifications. With a top level folder for each subject area, the web cat folder structure looks like this:
Samplesales demo data set makes a difference between column prompt (to filter a column) and other prompt purpose.
Oracle BI Presentation Service provides a pure browser-based administration tool to administer a Web Catalog.
Administrators can:
The installation of OBIEE provides also a desktop tool: the catalog manager
The runcat utility is a command line tool.
The webcatalog is located:
There are two ways to rename an object:
Do not rename the “My Dashboard” dashboards in the Users folder (displayed as _portal in Catalog Manager).
With runcat
runcat.sh -cmd repair -offlineRaw $CAT_PATH -outputFile $(pwd)/repair.log
With runcat
runcat.sh -cmd delete -path '/shared/shared' -offline $CAT_PATH
To delete a user or its content, see account managment
Only on 11g
A search engine can be configured to crawl and index the Oracle BI Presentation Catalog to be able to perform a full-text catalog search for objects and attachments. More … Configuring for Full-Text Catalog Search