| 1 . | Double-click the Revenue logical column to open the Logical Column dialog box.  |
|---|---|
| 2 . | Click the Aggregation tab.  |
| 3 . | Change the default aggregation rule to Sum.  |
| 4 . | Click OK to close the Logical Column dialog
box. Notice that the icon has changed for the Revenue logical column
indicating that an aggregation rule has been applied.  |
| 5 . | Repeat the steps to define the SUM aggregation rule for the Units logical column.  Measures are typically data that is additive, such as total dollars or total quantities. The F1 Revenue logical fact table contains the measures in your business model. You aggregated two logical columns by summing the column data. |
| 6 . | Save the repository without checking global consistency. Congratulations! You have successfully built a business model in the Business Model and Mapping layer of a repository and created business measures. |
OBIEE 11G Create Simple Measures
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