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...
A Column Selector view adds a column selector to the results. A column selector is a drop-down list from which users can dynamically...
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...
TABLE SALESPEOPLE SNUM SNAME CITY COMM 1001 Pe...
You can use variables in a repository to streamline administrative tasks and modify metadata content dynamically to adjust to a changing...
1) I would like to know in which cases we will use ' select object(s) only ' , ' object(s) and direct joins ' and '...
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 set of steps you set up and use aggregate tables to improve query performance. Aggregate tables store pre-computed results, whic...