Return to Oracle BI, which should still be open. If not,
open a browser or browser tab and enter the following URL to navigate to
Oracle Business Intelligence:
In this tutorial the URL is http://localhost:7001/analytics.
If necessary, log in as an administrative user. Typically
you use the administrative user name and password provided during the
Oracle BI installation. In this example the user name is weblogic.
|3 .||In the left navigation pane, under Create... Analysis and Interactive Reporting, select Analysis. Hint: If your session has not timed out, you can create a new analysis by selecting New > Analysis.
|4 .||Select the Sample Sales subject area.
|5 .||In the left navigation pane, expand the Base Facts folder and confirm that the Actual Unit Price and Revenue Rank columns are visible.
|6 .||Create the following analysis by double-clicking column names in the Subject Areas pane:
Base Facts.Revenue Rank
Base Facts.Actual Unit Price
|7 .||Sort Revenue Rank in ascending order.
|8 .||Click Results to view the analysis results.|
Please note that the Actual Unit Price calculation is correct, although it does not make sense from a business perspective. For example, the unit price for an LCD HD Television would not be 9 dollars. This is a result of the underlying sample data.
OBIEE 11G Create and Run an Analysis
Labels:physical layer OBIEE 11g
A presentation variable can be created as part of the process for creating a column prompt or a variable prompt. When the presentat...
You create a Narrative view to provide information such as context, explanatory text, or extended descriptions along with column v...
TABLE SALESPEOPLE SNUM SNAME CITY COMM 1001 Pe...
A Column Selector view adds a column selector to the results. A column selector is a drop-down list from which users can dynamically...
How to get a difference between two dates (in terms ) of days,weeks,months what every it may be The below formula gives you no.of days b...
In this topic, you learn how to create an analysis with a Pivot Table view, format, add a calculated column to a pivot table, add a...
A dashboard prompt is a special filter that filters analyses embedded in a dashboard. There are two various prompts and this topic dis...
You can use variables in a repository to streamline administrative tasks and modify metadata content dynamically to adjust to a changing...
Calculating grand total column or % of grand total is easy in pivot table view. But how can I create the same in a table view? ...
In this set of steps you set up and use aggregate tables to improve query performance. Aggregate tables store pre-computed results, whic...