Friday, July 11, 2014

OBIEE 11G Oracle BI Answers Object explanation

Oracle BI Answers Workspace
Tab
Description
Criteria Tab
Use the Criteria tab to view or change the columns and filters for the request. You can specify the order in which the results should be returned, column subtotals, formatting (such as headings and number of decimal places), and column formulas (such as adding a Rank or Percentile function). You can also add or modify column filters.
Four common views are available from this tab by clicking the appropriate view button:
Displays the compound layout view, where you can combine individual views and arrange them for display on a dashboard.

Displays the table view, where you can show results in a table.

Displays the chart view, where you can show results in different kinds of charts.

Displays the pivot table view, where you can take row, column, and section headings and swap them around to obtain different perspectives.
Results Tab
Use the Results tab to work with the results of a request, and create different views of the results such as charts, tickers, and pivot tables. You can add a variety of views, including charts and pivot tables that show the data, plain or formatted text that describes the results, HTML, and more.
The default results view is a simple table with a title. Your Oracle Business Intelligence Presentation Services administrator may have configured a different default results view for your organization.
You can combine views and position them anywhere on the page. For example, you can create side-by-side pivot tables that reflect different views of the data, charts that allow you to explore interrelationships in depth, and filters that limit the results. If the request is embedded in a dashboard, the dashboard page can also include links to additional requests of interest, related graphics, news stories, and so on.
Prompts Tab
Use the Prompts tab to create prompts that allow users to select values to filter a request. Prompts allow users to select values that dynamically filter all views within the request.
Advanced Tab
Use the Advanced tab to work directly with the XML and logical SQL generated for the request. If you know SQL and the structure of your underlying data sources, you can use the Advanced tab to view and work directly with the SQL statements generated for the request. For example, you can change the subject area or add advanced SQL statements.
The Advanced tab also provides access to links that you can use to execute saved requests from an external Web page, portal, or application.
NOTE:  The Advanced tab is recommended for use only by developers or experienced users with complex data analysis needs and capabilities. Only users with the appropriate responsibilities are given access to the Advanced tab.

No comments:

Post a Comment