OBIEE 10G/11G - Answer/Analytics

The criteria tab

The first aim of the criteria tab is to create a logical SQL which contains:

• columns,
• filter,
• and transformation.

To choose the columns needed, the user interact the subject area. A subject area is generally the Presentation Layer of BI Server which is a logical view of the data but you may access directly the source database through the direct database request subject area.

As the user selects columns, Oracle BI Answers builds a query. This query is referred to as “logical SQL”, since it expresses the logical content of the request. This logical query will be sent to the Oracle BI Server, which will interpret the logical query and create subsequent physical queries to the underlying data sources where the data is stored.

Oracle BI Answers simplifies the use of derived measures i.e. measures that are computed on a query result set such as ranks, Ntiles, standard deviations, running totals, moving averages, and moving medians. These derived measures are difficult to compute in SQL but are very useful — moving average and moving median are valuable functions for smoothing data and discerning trends.

The results tab

Once the query created, the results tab permit to show the data and to format them through different views:

• table
• create graph (charts, gauges,…),
• pivot tables,

The prompt tab

OBIEE - The answer Prompt

The advanced tab

The advanced tab permits the definition of answer manually when:

• the GUI is not able to do it.
• you want add some properties.

You can in this area define your own logical sql without using the criteria tab which allow for instance the use of multiple subject area in one answer in 10g.