| 1 . | Right-click the D5 Sales Rep logical table and select Create Logical Dimension > Dimension with Parent-Child Hierarchy.  |
|---|---|
| 2 . | In the Logical Dimension dialog box, on the General tab, name the logical dimension H5 Sales Rep.  |
| 3 . | Click Browse next to Member Key. The Browse window shows the physical table and its corresponding key.  |
| 4 . | Click View to open the Logical Key dialog box. Confirm that the Sales Rep Number column is selected  |
| 5 . | Click Cancel to close the Logical Key dialog box. |
| 6 . | Click OK to close the Browse window. |
| 7 . | Click Browse next to Parent Column. The Browse window shows the columns other than the member key. |
| 8 . | Deselect Show Qualified Names and select Manager Number as the parent column for the parent-child hierarchy.  |
| 9 . | Click OK to close the Browse window, but do not close the Logical Dimension dialog box. |
OBIEE 11G Create a Parent-Child Logical Dimension
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