Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
E-Business Suite Technology
Business Intelligence (EBS)
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: May 26, 2013 11:01 AM by
Dimension with header and lines information
May 26, 2013 11:01 AM
I am using Oracle 11g for database , Oracle Admin Tool for repository creation
Source : EBS R12
Target : OBIEE
In EBS R12 , I have gathered information about inspection [Inspection is our customized form in EBS , In Inspection we contain information about Jobs , WorkOrder , Asset etc]
Some Inspection form have header information only and Some Inspection form have header and line information as well [there is no measures]
I have confused about Header and Lines data in dimension tables ! how can I handle with it?
In All inspection form some fields are common in header information
Ryte now I have broke into two tables
1: Dimension [Header and Lines]
2: Factless Fact Table [Contains only FK]
I want how can I merge two dimensions for get common information about different inspections?
and how can I handle the Lines data in dimension table?
Please proposed the best technique
This content has been marked as final.
Show 0 replies