In the Web browser, enter the URL for Discoverer Plus. This will display the Connect to OracleBI Discoverer screen. The URL looks like the one given below:

http://<hostname>:<port>/discoverer/plus

Enter the login credentials for the bi_user in the Connect Directly section. Enter the username and password, and the database connect string as shown. Enter the EUL name in uppercase (BI_USER), and click Go. This will connect you to Discoverer Plus.

Note: Alternately, you can choose from the list of predefined connections. You can also create a private connection by using the login credentials for the database that you want to connect to. Also, note that when you have a stand-alone BI installation, which is not associated with the infrastructure database of the Oracle Application Server, you will see only the Connect Directly option, not the connections. To associate the BI installation with the infrastructure database, contact the middle-tier administrator.

When you connect to Discoverer Plus, the first step of the Workbook Wizard is displayed. Select the Open an Existing Workbook option, and click Browse.

This will display the list of all workbooks.

The Name Contains field can be used to filter the list of workbooks. Enter Sales in the Name Contains field to display only those workbooks, whose name contains Sales.

Note: You can select to View all workbooks or scheduled workbooks, by selecting the appropriate options from the View drop-down list. Also, you can select the list of workbooks displayed as a Workbook Tree or User Tree as shown in the images below. Observe the improved interface.

Expand the sign next to the workbook Sales &Profits by Time & Geography to see all the worksheets, and select the worksheet Sales Vs Profits By Year, and click Open. This will open the worksheet in Discoverer Plus.

The worksheet is shown below. Observe the new look and feel.

Select Edit > Add Worksheet to invoke the new Worksheet Wizard. Deselect the Title, Text Area, and Graph options. Select Table as the worksheet layout, and click Next.

In step 2 of the wizard, you select items to be included in the worksheet. Observe the new Search icon, which enables you to search for required folders. Click the Find icon.

This opens a Find dialog box. Select Contains as the Search by criterion, and enter Profits in the Search For field. Click Go. This displays two folders Profits and Profits Analysis. Select the Profits Analysis folder. Click OK.

You can see that Profits Analysis folder is selected in the step 2 of the wizard. Select the Sales Revenue, Profit, Year, and Region items by pressing and holding the Ctrl key. Click to move these items to the Selected list, and click Next.

You can choose to display or hide the folders in the Selected list by clicking the Views icon.

Also, note that you can create Conditions and Calculations from the respective pages while creating the worksheet. These can be defined later while you edit the worksheet too.

Step 3 of the Workbook Wizard is displayed. Retain the default options and click Finish.
Note: The next two steps of defining sorts and parameters are skipped here, because this is a simple worksheet. These can be defined later.

This is how the worksheet you created looks like:

Note that the steps in creating a new workbook by using the Workbook Wizard are similar to these steps.

Select the Edit > Rename Worksheet menu option. This displays the new Worksheet Properties dialog box. Enter the name of the worksheet as Regional Sales and Profits By Year-New and add a Description (optional). Click OK.

Click Save icon to save the workbook. Enter Sales&Profits By Time &Geography -XX as the name of the workbook, where XX are your initials, so that you do not overwrite the sample workbook. Click Save.

Select the Edit > Worksheet menu option. Open the Worksheet Layout page, select the option to display Page Items, and click OK.

Note: Observe the other options in this page to display graph, title, and text in the worksheet.

Now the Worksheet will look like this with an option to display the page items.

To arrange the items in this worksheet better, pivot the Year item to the page axis by dragging this item to the page axis. Alternately, you can select the appropriate option to pivot this item from the shortcut menu as shown in the image below.

Similarly, move the Region item to place it before the Sales Revenue SUM item. After pivoting Year to the page axis, and placing Region before Sales Revenue SUM, this is how the worksheet will look:

You can see that the worksheet items are arranged better now, and also that pivoting can be done interactively.

Add suitable data formats to the items in the worksheet. For example, you can apply currency formats to Sales Revenue SUM and Profit SUM items.

Note: You can apply the appropriate currency format by selecting the Format Data option from the shortcut menu. In the Format Data Dialog box, select appropriate currency options as shown below.

After applying these formats, the worksheet will look like this:

Open the Worksheet Properties dialog box. This can be done from the shortcut menu which appears when you click the worksheet name.

Alternately, this dialog box can be opened by selecting Edit > Rename Worksheet.

Go to the Table Format tab, and click the Gridline Color drop-down list and select a color for the gridlines in the worksheet. Click OK.

Note: Observe the enhanced interface and other options in this page to display gridlines, column headings, row numbers, and NULL values.

Now the worksheet looks like this: (Observe the change in the gridline color.)

To add Prod Category item, you can right-click the item and select Add to Worksheet from the shortcut menu. You can also do this by selecting the required item to be added, and by clicking the
Add to Worksheet icon (highlighted in the image below). Alternately, you can drag the item to be added from the Available Items pane, and drop it on the worksheet.

The worksheet with the newly added item is shown below. By default new items are added at the end. However, in the worksheet below, note that Prod Category is placed (pivoted) before Sales Revenue SUM.

Note: Similarly , you can also remove the items from the worksheet interactively.

Before proceeding with this exercise, interchange the positions of Region and Year items. (That is, move Region to the page axis, and Year to top axis). The worksheet now looks like this:

Select the Edit > Worksheet Layout menu option.
Note: You can alternately select Edit > Worksheet and open the Worksheet Layout page.

Select the option to add a graph to the worksheet, and select the option to display the graph below the worksheet. Click OK.

The worksheet will now look like the image below. Edit the graph type and subtypes to improve the visualization. Right-click the graph in the worksheet, and select the Edit Graph option from the shortcut menu.
Note: Observe that a simple Bar graph is added to the worksheet. However, the graph type and subtypes added may differ based on the last graph added in the workbook.

You can also edit a graph by clicking the Edit Graph icon on the toolbar.

Open the Type tab. Select Bar as the graph type, Split Dual-Y Bar as the graph subtype, and click OK.

The graph in the worksheet will now appear like this:

Click the Edit Graph icon on the toolbar, and go to the Styletab. From the Style drop-down list, select Regatta as the option and also select the option to display 3D Effect in the graph.

A sample of the graph style that you have selected is reflected in the page. Click OK.

After applying this graph style, this is how the worksheet looks like:

To add Fitline options, click the Edit Graph icon and open the Plot Area tab. Select Linear as the Fitline option for Profit SUM and Sales Revenue SUM. Click OK.

Note:This option can be found in the table under the section Select options for the series displayed in your graph.

The graph in the worksheet now shows the Fitline option added. Note that though sales revenues were raising, profits do not show this trend.

Note: You can also change the series colors from the Plot Area tab, as shown in the screen below:

The graph in the worksheet now looks like this:

In the graph, click the legend for the year 2001 to view the quarterly information.

The worksheet and the graph now display quarterly information. Change the Fitline option for both Sales Revenue SUM and Profit SUM series to Exponential. You can see that the Profits and Sales Revenues have started increasing exponentially in the year 2001.

You can click the icon for New Calculation (highlighted in the image). Alternately, open the Calculations page, right-click the My Calculations node, and select New Calculation option.

Enter My Profit Margin as the name for the calculation, and add a formula to calculate profit margin (Profit SUM/ Sales Revenue SUM) in the Calculation field. Click OK.

The Calculation will be added automatically to the worksheet as shown below. You can also see this calculation added to the My Calculations node and also in the Selected Items pane.

Note that the graph type used here is Line with a subtype Dual-Y Stacked Line.

Change the data format for My Profit Margin to represent it as a percentage, without decimals.

Now the worksheet looks like this:

Note: To save the changes that you are making to the worksheet, you can save the workbook. Also, if you want to save the changes as a separate worksheet in the same workbook, then you can duplicate the worksheet, and give it an appropriate name before saving the workbook. For example, you can name the above worksheet as Regional Profit Margins By Year. Duplicating a worksheet can be done from the Edit > Duplicate Worksheet menu option as shown below:

The image below displays a tabular worksheet, with Region pivoted to the top axis. This worksheet displays sales, profits, and profit margins for all the regions and years. To add a group sort on year (or in general, any sort on an item), you need just a single click. Select the item Year and click the group sort icon on the toolbar. You can also do the same from the shortcut menu of the item.
(Note that the worksheet layout is edited not to display page items and graph; and also font sizes for the items are changed.)

The worksheet looks like this after applying a group sort on Year:

To apply line breaks or page breaks right-click Year and select Format Data option.

Observe the tabs, and open the Breaks tab. Select to insert a line break at each change of value, select the line width as 3, and select a color for the line break as shown in the image below. Click OK.

Now the worksheet looks like this:

Note: You can select from custom colors, or edit the colors to add your own combinations of colors. Similarly, you can define page breaks too. Also, note that page breaks can be applied only to tabular worksheets and not crosstabs.

Similarly, add sorts on Sales Revenue SUM and Profit SUM to display these items in descending order.
Hint: Use the sort icon on the toolbar. Also, you can define sorts from Tools > Sort menu option.

Now the worksheet looks as shown in the image below. Observe that Americas and Europe Regions are doing well in terms of the sales revenues and profits. You can also see that profit margins declined in the year 2000, and started rising again in the year 2001.

To define a stoplight format on Profit SUM, select this item and click the New Stoplight Format icon on the toolbar.

The New Stoplight Format dialog box appears. Deselect the check box to automatically generate the name, and enter Stoplight for Profit SUM as the name of the format. Enter 250000 in the Unacceptable field, and 1300000 in the Desirable field. Click OK.

Note: You can also edit the default colors of red, green, and yellow to have your own combinations of colors to represent unacceptable, desirable, and other values.

Now the worksheet with stoplights applied on Profit SUM looks like this:

Now to define a conditional format on Sales Revenue SUM, select this item, and click the New Conditional Format icon on the toolbar. The New Conditional Format dialog box is displayed. Deselect the check box to automatically generate the name, and enter Conditional Format on Sales Revenue as the name. Select BETWEEN as the condition, and enter 5000000 and 17000000 in the two fields to define the range on values. To define the color formats, click Format.

Select colors as shown for the Text and the Background from the color palettes, select 14 as the Size of the font, and click the icon to select bold as the style. Click OK.

After applying both conditional and stoplight formats, the worksheet will appear as shown in the image below. Note that Americas and Europe regions are top contributors for the sales revenues and profits in all the years.

Note: You can edit the stoplight or conditional formats from the Format > Conditional Formats menu option, which will open the Conditional Formats dialog box.

Rename the sheet as Regions Contributing to Sales & Profits at a Glance and save the workbook.

Select the menu option Edit > Worksheet Layout, and select the options to add a Text Area and a Title to the worksheet as shown in the image below. Click OK.

Double-click the Title (found at the top of the worksheet), select Text and Background colors from the drop-down list. Select 16 as the font size, and select Bold as the style. Insert Sheet Name as title, and click OK.

Now the worksheet name is displayed as title.

Similarly, double-click the Text Area (found at the bottom of the worksheet), and from the Insert drop-down list select Conditional Formats to insert conditional format metatokens. Click OK. This helps in understanding the conditional and stoplight formats defined in the worksheet.

The worksheet now looks like this.

Note: You can further format the worksheet by adding formats on text, headings, and so on according to your requirements.