Using the Answers selection pane, perform the following:

a.	Drill on Channel, Geography, Product, and Time. Result: the dimension columns that you defined for the Presentation layer appear.
b.	Drill on Sales Cube. Result: the stored and calculated measures appear in the folders that you defined for the Presentation layer. When you select the measures and dimension levels that you want: The query is written against the OLAP cube views The OLAP engine retrieves stored data and solves all of the selected calculations at the requested level of detail.
c.	Under the Geography node, click Region. Result: Geography {Region} is added to the Criteria tab.
d.	Under the Sales Cube node, select the Sales measure.

The resulting display should look like this:

Click the Results tab (or the Display Results button). Sales for the Geographical regions appears in the display.

Note: the Sales values are automatically returned for the "All" level in the other three dimension, as follows: Channel = "All Channels"; Product = "All Products"; Time = "All Years". The correct level of aggregation for these dimensions is returned because of the level-aware OLAP cube metadata that is part of the repository.

In the Results tab, drill on Europe. Sales data for the European countries are returned.

In the Answers selection pane, drill on Time and select Calendar Year. The Results display should now look something like this:

Click the Criteria tab, then click the Filter tool for Time.

Select the year 2009 by entering CY2009 in the Value box. Then click OK.

Result: the following filter critera now appears:

Under the Columns section of the Criteria tab, drag the Time tile before Sales, like this:

Click the Results tab. The report should look like this:

In the row for France, drill on CY2009. The following results appear:

The query automatcially returns data for the lowest level in the drill path.

Once again, click the Criteria tab.

As shown, BI Answers records changes to the query in the Filter section. You can modify, save, or remove any filter.

Save the filter on Calendar Year, as follows:

Result: the saved filter is added to the My Filters folder:

In order to start a new query, click the Remove Filters button:

Then, click the Remove All (Columns) button:

From the BI Answers navigation pane, click on the following items (in the order specified):

	All Regions (from Geography)
	Calendar Year (from Time)
	Department (from Product)

Then, from the Sales Cube measure folder:

	Sales
	Sales Ytd Pr Yr Pct Chg
	How is Sales Ytd

The resulting Criteria display looks like this:

Apply the same filter to the Time dimension that you created previously, by using the saved filter:

Modify the Sales Ytd Prior Year % Change measure to show two decimal places.

Click the Results tab to view the data.

Notes:

The How is Sales Ytd measure is a custom OLAP calculation that returns a text value based on performance of the Sales Ytd Prior Year % Change measure. If the percent change in YTD Sales is above 15%, "Outstanding" is returned. If the percent change is between 0 - 15%, "On track" is returned. If the percent change is negative, "Needs Improvement" is returned.

The stored and calculated OLAP data is returned, with each measure result correctly computed for the selected dimension levels. In this case: Geography = "All Regions"; Time = "Calendar Year" (where year = CY2009); Product = "Department"; Channel = "All Channels"

Click the CY2009 link in the table to drill down. The results should now look like this:

Again, all measure data is computed perfectly.

Next, click the Q1-CY2009 link in the table to drill down. The table should now look like this:

Notice that the How is Sales measure shows the Cameras and Camcorders product department is under-performing in both January and February. The the Sales Ytd Prior Year % Change measure provides the data points.

Click the Cameras and Camcorders link in Feb-2009 to drill down. The table should now look like this:

Notice that the Cameras and Accessories product category is the problem area in the selected time period.

As you can see, the power and performance of the Oracle OLAP Option is easily accessible to Oracle BI Answers, and all other Oracle BI EE tools. In addition, creating the appropriate metadata is quick and easy, as described in Creating BI EE Metadata for OLAP Cubes.

After you finish experimenting with the data, simply close the browser to exit BI Answers.