OBIEE 10G/11G - Answer/Analytics

Saw Object


(Answers 10g|Analyses 11g) is the base component of BI Presentation Service to create Web report . It provides:

  • ad-hoc query
  • and analysis capabilities.

The definition of an answer is principally composed of :

  • a logical SQL to retrieve data
  • the visual definition/properties of the data (which graph, which colors, …)

All visual data representations are interactive and drillable and can be saved, shared, modified, formatted, or embedded in the user’s personalized Dashboard or Enterprise Portal.

Answer is also the entry point component to write back data in the data source.

Analysis Editor

The GUI of answer is composed of 5 tabs.

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:

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.

The analysis must not contain features such as hierarchical columns, selections, or groups.



  • Home and Header > New Menu
  • Access > Access to Answers
  • Subject Area > Access within Oracle BI Answers


Documentation / Reference

Discover More
Saw Object
OBIEE - (Answer|Analytics) Views

View (data displays) are used to display the data result set of an analysis. They are build using ADF DVT. Adding...
Saw Object
OBIEE - BI Presentation Service (SAW/OBIPS)

AnswersInteractive DashboardsDelivers The Oracle BI Presentation Service Server: is a pure Web Environment visualize data from the Oracle BI Server through the creation of Interactive Dashboards...
Bi Server Architecture With Client
OBIEE - BI Server Clients (ODBC, JDBC)

The Open interface of BI Server gives the possibilities to made a client connection throught ODBC and JDBC. Clients of the Oracle BI Server see a logical schema view independent of the source physical...
Obiee 10g Briefing Book Save
OBIEE - Briefing Book

A Briefing Book is a collection of static or updatable snapshots of : an Oracle BI Interactive Dashboard. of an individual analyses (Answer) and BI Publisher reports (for 11G) It allows that content...
Column Formula
OBIEE - Criteria Tab

The criteria tab of an answer is a GUI that help you to create the logical SQL. In a column formula, you can add: comment a presentation column a presentation variable a bi server variable...
Obi Edition
OBIEE - Delivers

Delivers is an alerting engine to capture and distribute automatically scheduled notifications, alerts and contents Alerts to individuals or groups via multiple channels such as : email, dashboards,...
Obiee Filter Advanced Convert To Sql
OBIEE - Filter on current time

How to filter based on the current time in an answer. You have two objects that store the current time: @{system.currentTime} : it's a presentation variables system where you can find the current...
Obiee Guided Navigation
OBIEE - Guided Navigation

Guided navigation is a feature of Oracle BI Interactive Dashboards that enables the content and layout of Oracle BI Interactive Dashboard to change dynamically based on changes in the information being...
Obiee Ceim
OBIEE - Logical Sql

The logical SQL is the SQL that understand BI Server. It's a full Ansi 92 SQL (including subqueries and derived tables), plus special functions (SQL extensions) like AGO, TODATE, EVALUATE, and others....
Obiee11g Lts
OBIEE - Logical Table Source (LTS) (Physical and Logical Column Mappings)

Logical table sources definethe mappings from a single logical table to one or more physical tables. A logical table contains one or more logical table source. The mapping between physical columns and...

Share this page:
Follow us:
Task Runner