Home  >  Blog  >   IBM Cognos

How to Create Master Detail Relationship in Cognos Report Studio

Rating: 5
  
 
6705

How to Create Master-Detail Relationship in Cognos Report Studio

  • The 2 containers can be merged using master details relationship

  • The 2 containers should have a common query item to merge the data

  • Add the following query items to the list

  • Staff name

  • Order number

  • Order date

  • Revenue

  • From toolbox,

  • Drag the list drop beside the revenue

  • Add the following query items to the list2

  • Order number

  • Product name

  • Description

  • Quantity

  • From List2,

  • Select order number

  • From the toolbar click on the cut

  • From list2,

  • Select quantity

  • From the data menu,

  • Select aggregate

  • Click on total

  • From data menu

  • Select Master-Detail relationship

  • Click on a new link

  • From list2

  • Select quantity

  • From data menu

  • Select aggregate

  • Click on total

  • From data menu

  • Select Master Detail relationship

  • Click on a new link

  • From query1

  • Select order number

  • From query2

  • Select staff name

  • From structure menu

  • Click on Group

  • From structure menu

  • Select Headers & Footers

  • Click on create headers

  • Select the staff name header cell

  • From toolbar, click on delete

  • Edit the fonts

  • Run the report

MindMajix Youtube Channel

 

Enroll for Instructor Led Live Learn Cognos Course

 

Master-Detail Relationship Report

 

Master Detail Relationship Report
Master Detail Relationship Report_2
Master Detail Relationship Report_3
Master Detail Relationship Report_4
Master Detail Relationship Report_5

Master Detail Relationship Report_6
Master Detail Relationship Report_7
Master Detail Relationship Report_8
Master Detail Relationship Report_9
Master Detail Relationship Report_10

 

Related Articles: 

Cognos Interview Questions and Answers

Tableau Vs Cognos

Cognos Tutorial

 

 

 

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
IBM Cognos TrainingApr 27 to May 12View Details
IBM Cognos TrainingApr 30 to May 15View Details
IBM Cognos TrainingMay 04 to May 19View Details
IBM Cognos TrainingMay 07 to May 22View Details
Last updated: 03 Apr 2023
About Author

Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

read more
Recommended Courses

1 / 15