| 1. |
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: http:// In this tutorial the URL is http://localhost:7001/analytics. |
|---|---|
| 2. |
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: Products.Product Base Facts.Revenue Base Facts.Revenue Rank Base Facts.Units 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
Subscribe to:
Post Comments (Atom)
Popular Posts
-
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...
-
https://forums.oracle.com/forums/search.jspa?forumID=378&threadID=&q=%22timestampadd%22+&objID=f378&dateRange=all&userI...
-
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 create time series calculation measures using Oracle BI time series functions. Time series functions include AGO, T...
-
In OBIEE, the dashboard prompts are aligned to the left by default. One of the OBIEE developers I am working with asked me to fin...
-
I was requested the other day for a custom job within OBIEE. The request was for an extra “Go” button which would be placed on to...
-
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 presentation variable can be created as part of the process for creating a column prompt or a variable prompt. When the presentat...
-
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? ...
No comments:
Post a Comment