In this lesson, you will learn how to copy the BI Beans objects,
such as presentations, calculations, and saved selections, from your local file
system to a remote BI Beans Catalog in the database.
You also learn how to browse the remote catalog from JDeveloper.
Move your mouse over this icon to show all screenshots.
You can also move your mouse over each individual icon to see only the screenshot
associated with it.
Overview
The definitions of BI Beans objects are stored in the local
BI Beans catalog on the developer's machine. They can also be copied to a remote
BI Beans Catalog, defined in an Oracle database. This allows analyses to be
shared within a user community.
This lesson shows you how to copy BI Beans objects to the
remote catalog, and then how to browse the remote catalog from JDeveloper.
Complete the lesson entitled 'Creating
Business Intelligence (BI) Objects'.
2.
Complete the lesson entitled 'Using the QueryBuilder'.
3.
Complete the lesson entitled 'Formatting
Presentations'.
4.
Install a BI Beans remote catalog
using the instructions in the BI Beans Help topic: Installing
and Configuring the BI Beans Catalog.
To find this Help topic, navigate from JDeveloper's
main Help menu to: Building Applications with BI Beans > Getting Started
> Installing and Configuring the BI Beans Catalog.
Copy Objects to the BI Beans Remote
Catalog
When you copy objects to the remote catalog,
you must do the following:
A)
Specify a connection
to the remote catalog.
B)
Identify the folders
and objects in your local catalog that you want to copy.
Follow these steps to copy objects to the BI Beans remote
catalog:
1.
In the Applications-Navigator
pane, right-click on the BI Designer for your project (for example , Project1BIDesigner1)
and choose Copy Objects to Remote Catalog.
The Copy Objects to Remote Catalog Wizard opens.
In the Welcome screen, click Next.
2.
In Step 1 of the Wizard, you can either specify
an existing connection or add a new connection.
If you have already defined a connection to
the remote catalog, select that connection and skip to Step 8.If you need to add a new connection, click New
and continue with Step 3.
3.
In the Welcome screen
of the Catalog Connection Wizard, click Next.
4.
In the Step 1 of the Catalog Connection Wizard, accept
the default connection name (for example, CatalogConnection1) and the
connection type Oracle(JDBC).
Click Next to continue.
5.
In Step 2 of the Catalog Connection Wizard, enter the required
Username and Password. Use BIBCAT as
the username and password for the Catalog that you installed in Installing
the BI Beans Catalog.
Note: BIBCAT must be in uppercase. BIBCAT is the username and password
for the BI Beans Remote Catalog schema owner.
Click Next to continue.
6.
In Step 3 of the Catalog Connection Wizard, select thin
for Driver type, then enter the host name, JDBC port, and SID for the
database connection.
Click Next to continue.
7.
In Step 4 of the Catalog Connection Wizard, click Test
Connection.
Choose Finish if the connection is
successful to close the Catalog Connection Wizard.
8.
In Step 1 of the Copy Objects to Remote Catalog Wizard,
enter BIBCAT as the Catalog user and
click Test.
Note: BIBCAT must be in uppercase. BIBCAT is also the default user that
is created for the Remote Catalog.
Choose Next to continue.
9 .
In Step 2 of the Copy Objects to Remote Catalog Wizard,
select the following three objects: Sales Revenue Growth %,
Sales Analysis Crosstab, and Sales Analysis Graph.
Choose Finish to copy the selected
objects to the Remote Catalog.
10 .
After the copying process has successfully completed, review
the summary messages to ensure that there are no errors, and choose Close.
Browse the Remote Catalog
You can view objects in the remote catalog by
using the BI Explorer, which may be launched from JDeveloper. Follow these steps
to view the objects that you copied the remote catalog in the first topic.
in the Applications-Navigator, under Project1.jpr,
right-click Project1BIDesigner1 and choose Browse Remote Catalog.
The Browse Remote Catalog dialog box is displayed.
2.
Select the catalog connection that you specified
when you copied objects to the remote catalog (for example, CatalogConnection1),
accept the default user, and choose OK.
The BI Explorer utility is opened.
3.
BI Explorer provides functionality that is
similar to the functionality that Windows Explorer provides for your local
file system. You should see the copied objects in the root folder of the
remote catalog.
4.
From the File menu, choose Exit
to exit the BI Explorer.
5.
In JDeveloper, from the File menu, choose Save
All to save your work.
Summary
In this lesson, you learned how to copy objects to the BI
Beans remote catalog. By storing objects in a persistent database, you facilitate
object management and deployment for BI Beans applications.
Bookmark
