Creating Web Catalog and Reports

Creating Web Catalog and Reports:

1)   How many ways to rename an Object?

A) There are two ways to rename an object:

a. Rename without reference updates — Renames the object and preserves the reference original name  that other catalog objects might have .

b. Rename with reference updates — Renames the object and changes references that other objects might have to the new name (that is, original name references are not preserved).

You must open the catalog in offline mode.

c.Do not rename the “My Dashboard” dashboards in the Users folder (displayed as _portal in

Catalog Manager).

2) what is instanceconfig.xml file?

A)The instanceconfig.xml file stores the configuration settings that affect Oracle BI Presentation  Services.

3) what is sawlog file?

A)By default, Oracle BI Presentation Services is configured to log all error events and formational and warning events of sufficient importance. An example of an important informational event is a server starting up or a server shutting down. Log files are named sawlogxx.log, where the xx is replaced by an incremented number.

The sawlog0 file is located:

• on 10g: OracleBIData/web/log
• on 11g: ORACLE_INSTANCE/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obipsn.

4) How to deploy a simple catalog object to a production environment?

1.       If you are deploying a catalog object to a new production environment.

Archive the catalog object in the test environment and unarchive it in the production environment as follows:

a.       Archive the catalog object in the test environment using one of the following:

·         Oracle BI Presentation Services.

·         Catalog Manager.

b.      Copy the archived file to the production computer.

c.       On the production computer, unarchive the object.

5) What is catalog group?

A) A catalog group is defined locally in Oracle BI Presentation Services and is used to grant privileges in the Oracle Business Intelligence user interface in addition to granting Oracle BI Presentation Catalog permissions.

6)  How to create catalog groups?

A) To create Catalog groups:

1.      From the Home page in Presentation Services, select Administration-> Manage Catalog Groups -> Create a New Catalog Group

2.      In the Add Group dialog, enter a name for the group.

3.      Use the shuttle control to select the Catalog groups, users, and application roles to include in this group.

7) What is Application Role?

A) Represents a role a user has when using Oracle Business Intelligence. Is also the container used by Oracle Business Intelligence to grant permissions to members of a role. Application roles are managed in the policy store provider.