✍ Kashif M
Trends

Friday, 20 June 2014


Ragged and skipped level Hierarchy in OBIEE 11g


By on June 20, 2014




· Open custom repository in Offline mode.

· Save it as PCSR_Hierarchies(parent child, skipped and ragged).

· Import GCBC_Sales.Staff_parent_child and Stores_ragged tables into physical layer.

· Create Alias tables.

· Staff_parent_child --> Dim_staff_parent_child.Store_ragged --> Dim_stores_ragged.

· Select Dim_staff_parent_child, Dim_stores_ragged and fact_sales and open the physical diagram.

· In the physical diagram join "Dim_stores_ragged"."store_pk"="fact_sales"."store_id". and "Dim_staff_parent_child"."staff_id"="fact_sales"."staff_id".

Kashif
mkashu: Ragged and skipped level Hierarchy in OBIEE 11g
Review : Kashif | Kashif
Update: June 20, 2014 | Rating: 4.5

Comment for "Ragged and skipped level Hierarchy in OBIEE 11g"

0 comments

Post a Comment

Blog Archive