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.
|
Overview | |
|
Prerequisites | |
|
Copy Objects to the BI Beans Remote Catalog | |
|
||
|
Summary | |
15 minutes
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.
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.
In order for this lesson to work successfully, you will need to have performed the following:
| 1. | 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. |
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.
|
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.
| 1. | 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.
|
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.
Move your mouse over this icon to hide all screenshots