1 . | In the Business Model and Mapping layer, right-click the F1 Revenue table and select New Object > Logical Column to open the Logical Column dialog box. |
---|---|
2 . | On the General tab, name the logical column Product Share. |
3 . | On the Column Source tab, select "Derived from existing columns using an expression." |
4 . | Open the Expression Builder. |
5 . | In the Expression Builder, Select Functions > Mathematic Functions > Round.
|
6 . | Click Insert selected item. The function appears in the edit box. |
7 . | Click Source Number in the formula. |
8 . | Enter 100* followed by a space. |
9 . | Insert Logical Tables > F1 Revenue > Revenue. |
10 . | Using the toolbar, click the Division button. Another set of angle brackets appears, < |
11 . | Click < |
12 . | Insert Logical Tables > F1 Revenue > Product Total Revenue. Recall that this is the total measure for the hierarchy. |
13 . | Click between the last set of angle brackets, < |
14 . | Check your work: Round(100* "Sample Sales"."F1 Revenue"."Revenue" / "Sample Sales"."F1 Revenue"."Product Total Revenue" , 1) This share measure will allow you to run an analysis that shows how revenue of a specific product compares to total revenue for all products. |
15 . | Click OK to close the Expression Builder. The formula is visible in the Logical Column dialog box. |
16 . | Click OK to close the Logical Column dialog box. The Product Share logical column is added to the business model. |
17 . | Add the Product Share measure to the Base Facts presentation table. |
18 . | Save the repository. Check consistency. You should receive the following message. If there are consistency errors or warnings, correct them before you proceed. |
19 . | Close the repository. |
OBIEE , INFORMATICA, OBIA DAC TRAINING FOR DETAILS CALL 09959531832 email ID: obieetraining03@gmail.com
OBIEE 11G Create a Share Measure
Labels:physical layer
OBIEE 11g
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