Blog

  • Home
  • Cognos
  • How to Create Master Detail Relationship in Cognos Report Studio

How to Create Master Detail Relationship in Cognos Report Studio

  • (5.0)
  • | 3741 Ratings

Master Detail Relationship Report

  • 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 toolbar click on cut
  • From list2,
  • Select quantity
  • From data menu,
  • Select aggregate
  • Click on total
  • From data menu
  • Select Master Detail relationship
  • Click on new link
  • From list2
  • Select quantity
  • From data menu
  • Select aggregate
  • Click on total
  • From data menu
  • Select Master Detail relationship
  • Click on 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
Enroll for Instructor Led Live Learn Cognos Course

Master Detail Relationship Report

Master Detail Relationship ReportMaster Detail Relationship Report_2Master Detail Relationship Report_3Master Detail Relationship Report_4Master Detail Relationship Report_5

Master Detail Relationship Report_6Master Detail Relationship Report_7Master Detail Relationship Report_8Master Detail Relationship Report_9Master Detail Relationship Report_10

Frequently Asked Cognos Interview Questions & Answers


Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.

Ravindra Savaram
About The Author

Ravindra Savaram is a Content 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.


DMCA.com Protection Status

Close
Close