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, enter Product Total Revenue in the Name field. |
||||||
3 . | Click the Column Source tab. |
||||||
4 . | Select Derived from existing columns using an expression. |
||||||
5 . | Open the Expression Builder. |
||||||
6 . | In the Expression Builder, add Logical Tables > F1 Revenue > Revenue to the expression. Recall that the Revenue column already has a default aggregation rule of Sum. |
||||||
7 . | Click OK to close Expression Builder. |
||||||
8 . | Click the Levels tab. |
||||||
9 . | For the H2 Product logical dimension, select Product Total
from the Logical Level drop-down list to specify that this measure
should be calculated at the grand total level in the product hierarchy. |
||||||
10 . | Click OK to close the Logical Column
dialog box. The Product Total Revenue measure appears in the Product
Total level of the H2 Product logical dimension and the F1 Revenue
logical fact table. |
||||||
11 . | Repeat the steps to create a second level-based measure:
|
||||||
12 . | Expose the new columns to users by dragging Product Total Revenue and Product Type Revenue to the Base Facts presentation table in the Sample Sales
subject area in the Presentation layer. You can drag the columns from
either the H2 Product logical dimension or the F1 Revenue logical table.
|
OBIEE , INFORMATICA, OBIA DAC TRAINING FOR DETAILS CALL 09959531832 email ID: obieetraining03@gmail.com
OBIEE 11G Create Level-Based Measures
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