1 . | Right-click H2 Product and select New Object > Logical Level. |
---|---|
2 . | Name the logical level Product Total . |
3 . | Because this level represents the grand total for products, select the Grand total level check box. Note that when you do this, the Supports rollup to higher level of aggregation field is grayed out and protected. |
4 . | Click OK to close the Logical Level dialog box. The Product Total level is added to the H2 Product logical dimension. |
5 . | Right-click Product Total and select New Object > Child Level to open the Logical Level dialog box. |
6 . | Name the logical level Product Brand. |
7 . | Click OK to close the Logical Level dialog box. The Product Brand level is added to the logical dimension. |
8 . | Repeat the steps to add the following child levels: Product LOB as a child of Product Brand Product Type as a child of Product LOB Product Detail as a child of Product Type Use the screenshot as a guide: |
OBIEE , INFORMATICA, OBIA DAC TRAINING FOR DETAILS CALL 09959531832 email ID: obieetraining03@gmail.com
OBIEE 11G Create Logical Levels
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