First create a new Workspace. From the File menu, select New. The New Gallery dialog box opens.

In the New Gallery dialog box, under Categories, select General; under Items, select Workspace and click OK.

The Create Workspace dialog box opens.

In the Create Workspace dialog box, accept the default name and directory for the workspace.

Note: Make note of the path for your workspace Directory Name.

Ensure that the Add a New Empty Project box is not checked, as shown in the screen shot below:

Click OK to create the Workspace. Click the Save All tool to save the Workspace.

Save the following self-extracting archive, Project1.exe, to your local machine.

For example, use your browser's right-mouse menu to perform a Save As.

Note: Due to virus protection rules, the self-extracting archive may copy to your machine with the name Project1, rather than Project1.exe. If this is the case, you will need to rename the file on your local machine by adding the .exe extension before extracting its contents.

Once you have downloaded the archive, and renamed it if necessary, extract the contents of the archive using the following steps:

The BI Beans OBE project is unzipped into your workspace directory.

Close the WinZip Self- Extractor dialog.

In the JDeveloper Applications-Navigator, select the new Workspace that you just created in Steps 1. - 3.

Then, from the main menu select File > Open.

In the Open dialog, navigate to the Project1 directory below your workspace directory. This directory was created when you extracted the archive in Step 4.

Select Project1.jpr

Click Open.

The Workspace and associated Project are displayed in the Navigator.

Expand all of the nodes in the Workspace, and you should see the following project files in the Applications-Navigator:

Now, you must specify your database connection to the Oracle Common Schema analytic workspace in the BIDesigner. To do this, perform the following:

From the File menu, choose Save All.

In the Navigator, right mouse click on Project1 and select New from the pop-up menu.

In the New Gallery dialog box, select General from Categories panel and select Empty Project from the Items panel

Then click OK.

Accept the default values provided in the Create Project dialog and click OK.

From the main menu, choose File > Save All.

In the Navigator, right-click on the Project that you just created in the previous topic. Select New from the pop-up menu.

In the New Gallery dialog box, perform the following:

The Complete BI JSP Application wizard is opened. This wizard, which is comprised of one dialog box, contains options for JSP application functions, or components.

Here, you select the options that you want added to your application.

First, select the BI Runtime Configuration file that the application will use. This file contains the connection information for your OLAP data connection and the location of your BI Beans objects.

By default, the Project1OLAPConfig1.xml - [Project1] file should be selected in the Runtime Configuration file list. If not, select this file from the drop-down list.

Next, specify the presentation that is to be displayed when the application starts. To do this, Select the Show a Default Presentation option, and then click the Browse button.

The Open dialog box is displayed.

In the Open dialog box, select Sales Analysis Crosstab and click OK.

The Sales Analysis Crosstab is displayed in the Location box of the Complete BI JSP Application wizard.

Now, select all of the other JSP application function options, as shown here:

Click OK to generate the application.

A set of project files are created for your BI JSP application.

Note: When you first create a JSP application using this wizard, a Readme page is displayed. Review the Readme page, which describes all of the project files that are created as part of a JSP applications.

When you are finished reviewing the Readme file, close it by clicking the 'X' next to it's name, as shown below:

From the main menu, choose File > Save All.

In the Applications - Navigator, right-click on Analyze1.jsp and select Open to load the primary JSP application page.

Once the application loads, the JDeveloper window layout should be divided into five areas as descibed below.

	Area 1: Applications-Navigator – Shows a list of project components, such as Designers, Java files, XML files, HTML FILES, etc.
	Area 2: Design/Source Window – Consists of two tabs: - The Design tab – Displays the UI view of the application and allows a developer to edit the design visually. - The Source tab – Displays the the JSP tags and allows a developer to edit the application code directly.
	Area 3: Structure Window – Displays a view of application objects in a hierarchical drillable tree mode. This display is dependent on the tab that is selected in Area 2, and it refreshes automatically when you select a different tab.
	Area 4: Component Palette – Displays a list of JSP and HTML components that can be used within an application.
	Area 5: Property Inspector – Displays a window that is linked to the Structure window. Selecting a component in the Structure window updates the Property Inspector.

To check the structure of the application, it is recommended to compile (Make) the application code.

In the Navigator, right-click Analyze1.jsp and choose Make from the popup menu.

The status bar at the bottom of the JDeveloper window should report that the compile process is successful.

Right-click Analyze1.jsp and choose Run from the popup menu.

JDeveloper's embedded OC4J server is started, and the application is loaded into memory.

The running application is displayed in a new window and starts by showing the Stoplight Report crosstab that was selected as the default presentation.

The page is divided into three main sections:

	Main toolbuttons The toolbuttons allow users to update the current report, save the report to a new name, print the current report, export the current report, create a new calculation, or edit the query for the report. The toolbuttons are also displayed at the bottom of the application window. Note: For the Export feature, supported formats include: MS Excel HTML (*.htm), Tabbed Text (*.txt), and Comma Separated Values (*.csv).
	Presentation toolbar The toobar allows users to change the view from crosstab to graph and vice versa, change the layout of the current report, modify the format and stoplight formatting, sort dimension members, and access previously saved dimension selections. Select any one of the toolbar links to display the toobar menu that is associated with the selected tool. For example, the Format menu is expanded to show its options here:
	Presentation area, which contains the Crosstab or Graph.

Click the View tool.

In the View menu, select the Graph option. Then, change the graph type to Pie.

Click Go to update the report. The graph shows the contribution of Sales for each of the selected Geography dimension members.

Reset the view back to a crosstab by selecting the Crosstab option and clicking Go.

To change the member selection in Page Items dimensions, simply select the new dimension member from the drop-down list, and then click Go.

You can also scroll horizontally in the crosstab by clicking the appropriate link next to the Columns drop-down list. For example, click the Right link to view the measure data for the remaining selected products.

Scroll back to the left by clicking the Left link.

Change the orientation of the crosstab by using the Layout tool.

Click the Layout tool to display the Layout menu options. Select the following:

Click Go to update the crosstab.

In the year 2000, the Electronics product division contributed the most in terms of sales growth in the Americas. Now, drill on the Electronics division to view the data for its product groups.

The Game Consoles and Home Audio product groups are peforming the best based on sales growth.

Collapse the Electronics division by clicking the minus ("-") sign.

Finally, use the Layout tool to Swap the Product and Geography dimension again. This will re-establish the original orientation of the crosstab.

Modify the Geography member selection by using a Saved Selection.

Click the Saved Selections tool. In the Saved Selections menu, select the following:

Click Go to update the crosstab. The dimension members that were saved as European Areas are added to the Geography dimension selection in the report.

Modify the upper threshold of the stoplight format to 70%.

Click the Stoplight tool to display the stoplight options. In the Stoplight menu, specify the following:

Then, click Go.

The crosstab stoplight formatting updates to meet the new criteria.

Finally, change the layout of the crosstab once more before saving your changes to the crosstab as a new object.

Click the Layout tool to display the Layout menu options. Select the following:

Click Go to update the crosstab. The new layout should look like this:

Click the Save As button at the top right section of the application page.

In the Save As screen, enter the name Country Ranking Stoplight, and then click Save.

The name of the report is updated, and a new object has been added to the Catalog.

Click the Edit button in the top right corner of the report window. The Edit: screen is displayed.

Click the Refine Selections link. The Refine Selections tab displays the current selections for the measures and each dimension in the query.

In the Geography dimension, click the Delete (trash can) icon for both of the selection steps to remove the entire selection.

After deleting both steps, the Geography selection is empty:

Now, in the Geography dimension, click the Create Step button. The Step Type screen is displayed.

In the Step Type screen, select the Top / Bottom condition type that contains the following description: Top or bottom members based on a Measure, as shown here:

Click the Continue button to refine the condition.

In the top portion of the Top/Bottom Step screen, select the following options:

An OLAP ranking condition returns the appropriate dimension members for the condition by using a specific combination of values for the remaining,or qualifying, dimensions in the query. The values for these dimensions are displayed in the Qualify Measure region, in the bottom portion of the Top/Bottom Step screen

For example, our ranking condition as currently defined would return the top 10 products for Channel total, Product total , Promotion total and 1999, as shown here:

In an OLAP ranking condition, you can use the Qualify Measure region to select a different dimension member for each of the qualifying dimensions in the query.

Even more, you can specify that the ranking condition should be re-executed each time you select a new member from a qualifying dimension that is in the Page Items region of the crosstab. To do this, choose the Selected <Dimension> page item option in the dimension value drop-down list.

Use the dimension value drop-down lists to select the following:

Click Finish to add the new Geography dimension Step to the Query.

At the top of the Step Type screen, Click Apply to execute the new query and update the crosstab

With the inclusion of the new ranking condition, when you select members from one of the Page Item dimensions, the Top 10 Country list is refreshed for the current combination of selected dimension members.

For example, select the following dimension members from the Page Item dimensions: Electronics, Channel total, and 2000. Then click Go. The report shows the following top 10 Countries based on Sales Revenue:

Now, select these dimension members from the Page Item dimensions: Photo, Direct, and 2000. Then click Go. The report shows a new list of top 10 Countries with the appropriate ranking and stoplight formatting:

Feel free to experiment with the crosstab selections.

Note: As currently defined, the Geography ranking condition is designed to re-execute every time a new Product, Time, and Channel dimension member is selected. Therefore, while using this ranking condition, these three qualifying dimensions must be located in the Page Items region of the crosstab layout.

When you are done experimenting with the crosstab, save the Country Ranking Stoplight report by clicking the Save button.

Click the Catalog link at the top left section of the application page.

The Catalog browser is opened.

Click the link for the Sales Analysis Graph.

The graph is displayed in the application, replacing the crosstab.

First, use Query Editor to change the measures that are displayed in the graph.

Click the Edit button at the top right corner of the application page.

Then, in the Edit screen, click the Start With tab, which is shown below:

Using the Start With tab, follow these steps to add the Sales Costs measure to the graph:

Sales Cost is added to the list of measures in the graph.

Next, use the Layout tool to modify the layout of the presentation.

Click the Layout tool to display the Layout menu options and select the following:

Click Go to update the graph, which should now look like the following:

Select other members from the Page Items dimensions and see how the Top 5 Products list is re-evaluated based on the qualifying dimension members.

For example, the selection of Channel total, United States of America, and 2000 should create the following graph result:

Save the modified graph as a new object. First click the Save As button in the application page.

Enter Sales and Costs for Top 5 Photo Products as the name of the new graph, and then click Save.

The name of the report is updated, and a new object has been added to the Catalog.

To exit the application, simply exit the Browser.

Then, shut down the embedded OC4J engine by selecting Run > Terminate > Embedded OC4J Server from JDeveloper's main menu.