Developing OLAP Objects: 1. Setting Up Your project
1. Setting Up Your Project
Exercise Objectives
To define an Oracle JDeveloper9i Workspace, Project, and BI Designer framework.
Exercise Description
This exercise introduces you to the wizards that create the basic JDeveloper
containers. These containers, are needed to build a BI Beans application. Most
important is the BI Designer object, which is the container for business intelligence
objects. The BI Designer lets you construct, organize, and manage OLAP data
connections and objects.
Exercise Tasks
Create your JDeveloper Workspace and Project
Workspaces keep track of the projects and environment settings that you use while
developing your application. Projects are containers for the source files that are
used to create applications and applets.
To create a new JDeveloper Workspace and Project:
From the File menu, choose New.
In the New dialog box, under Categories, select General;
under Items, select Workspace. Choose OK.
In the New Workspace dialog box, accept the default workspace directory
name and specify BIWorkspace.jws for the workspace file name.
Ensure that the Add a New Empty Project box is
checked. Choose OK.
In the New Project dialog box, accept the defaults and choose OK.
Notice that the JDeveloper System-Navigator has been updated to display your
new workspace and project. To view the default project settings right-click
the project label Project1.jpr and choose Project
Settings. You will now create the framework for adding business intelligence
objects.
Create a new BI Designer
The BI Designer is used to aid in the visual development of your business intelligence
objects. It contains references to the information that is required for connecting
to Oracle9i OLAP and to the BI Beans Catalog. To create a BI Designer,
you use a wizard that prompts you for the following information:
A BI Designer name
An Oracle9i OLAP data source that is the source of your business
data
A local root folder in which you save your business intelligence object defintions
(crosstabs, tables, graphs, calculations and queries) during development.
To create a new BI Designer:
In the JDeveloper System-Navigator pane, select project Project1.jpr.
From the File menu, choose New.
In the New dialog box, under Category, select Business
Intelligence and, under Item, select Designer.
Choose OK. This invokes the BI Designer Wizard.
In the Welcome page, choose Next.
Accept the default name for your BI Designer and choose Next
to continue.
Select your Oracle9i OLAP data source. If this is your first time
connecting through JDeveloper, then you must set up the OLAP data source using
the following procedure:
Choose New. The Connection wizard is displayed.
In the Welcome page of the Connection wizard, choose Next.
Accept the default name OLAPConnection901_1 and enter Oracle
(JDBC) for your connection. Choose Next.
Enter the tutorial user id bibdemo and password bibdemo.
Leave Role blank and Deploy Password unchecked. Choose Next.
Accept the default Thin driver, enter the
hostname, JDBC port and SID of the Oracle9i OLAP server where you
have installed the
demo database bibdemo schema. Choose Next.
For a 9.0.1 database, after the wizard has searched for the available
OLAP service instances, expand the tree by clicking on the + sign. Choose
an OLAP service instance and click Test OLAP Connection.
For a 9.2 database, click Test OLAP Connection.
If the connection test is successful, then choose Next
to proceed; otherwise verify that Oracle9i OLAP is running and
check your connection information.
Choose Finish to complete the connection wizard.
In the BI Designer Wizard, choose Next to continue.
Accept the default directory that defines the root folder where your business
intelligence object definitions (for example, crosstab and graph definitions)
will be saved. Choose Next. If the wizard prompts
you to create the specified directory, then choose Yes.
Review the summary and choose Finish to complete
the BI Designer Wizard.
From the File menu, choose Save All to save
your work.
Notice that the JDeveloper System-Navigator has been updated to display the
newly created BI Designer object, a BI Configuration file (Project1BIConfign.xml),
and other *.DAD files. The BI Designer object holds the settings for your design
environment; the BI Configuration file holds the settings for your runtime environment.
Initially, these settings are identical. The *.DAD files contain OLAP and Catalog
connection settings. DAD stands for Database Access Descriptor.
To change the settings for either the BI Designer or the BI Configuration file,
right-click the BI Designer object or the BI Configuration file, and choose
Settings. This action displays the BI Beans Settings
dialog box that consists of the following tabs:
Design Settings - Lets you view and edit settings in your BI Designer object
Run Settings - Lets you view and edit settings in your BI Configuration
file
To test the OLAP connection that will be used during design, select the Design
Settings tab and choose Test. To test the OLAP connection that
will be used at runtime (if it is different from the design settings), select
the Run Settings tab and choose Test.
Exercise Summary
This section looked at the basic steps that are required to create a workspace, project,
and BI Designer. These objects act as containers for Java source files and for
the BI components that are used in the development of your application. The next section
shows you how to build business intelligence calculations (for example, variances,
time series calculations, and so on) using the CalcBuilder wizard.
Bookmark
