1 . | Return to Fusion Middleware Control and load the BISAMPLE repository. If you need help, click here to review steps from earlier in this tutorial. |
---|---|
2 . | Return to Oracle BI, which should still be open, and sign in. |
3 . | Create the following analysis to test the level-based and share measures. Products.Product Base Facts.Revenue Base Facts.Product Type Revenue Base Facts.Product Share |
4 . | For the Product Share column, select Column Properties. |
5 . | On the Data Format tab, select Override Default Data Format. |
6 . | Change Treat Numbers As to Percentage and set Decimal Places to 2. Deselect Use 1000's separator. |
7 . | Click OK to close the Column Properties dialog box. |
8 . | Sort Product Share in descending order. |
9 . | Click Results. Notice that Product Type
Revenue returns dollars grouped by Type even though the query is at a
different level than Type; Product in this example. Product Share shows
the percent of total revenue for each product sorted in descending
order. |
10 . | Sign out of Oracle BI. |
11 . | Click OK when you receive the message: Are you sure you want to navigate away from this page? |
OBIEE , INFORMATICA, OBIA DAC TRAINING FOR DETAILS CALL 09959531832 email ID: obieetraining03@gmail.com
OBIEE 11G Test Your Work
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