Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Duplicates when Joining header table to Detail table

User_IP06IMay 8 2018 — edited May 10 2018

Hello,

I have a Fact Header table and Fact detail table from which I've to create a single report. Whenever I Join the two tables the data is getting duplicated. Header amount is nothing but the sum of  detail amount by ID. I've the data as shown in the tables below. Please Suggest me how to model this in OBIEE and can you please show me how I can write a SQL query where the data won't be duplicated.

Thanks.

IDHeader amount
1300

IDLine numberDetail amount
11100
12200
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 7 2018
Added on May 8 2018
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
8 comments
679 views