Can any one expalain the procedure for How to create a
Mastr Detail Report in Cognos 8.3 ver?



Can any one expalain the procedure for How to create a Mastr Detail Report in Cognos 8.3 ver?..

Answer / pavan kumar

Def-: Two Data Containers can be merged by using common
query item is known as master Detail Report.
Procedure-:
1.)Take a List Report After that Add the following query
items to the List order_number,order_date,Staff_name and
Revenue.
2.)From toolbox drag the list drop beside the revenue.
3.)Add the following query items to the second list
order_number,product_name,Description and Quantity.
4.)From list2 select order_number from toolbar click on
cut.select the Quantity from datamenu select aggregate
click on total.
5.)From Data Menu select Master Detail Relationship click
on new link.From Query1 Select Order_Number,From Query2
Select Order_Number.
Click Ok.
Create a Group on Staffname Query item,
Create a Header on Staffname Query item.
Delete the Staffname HeaderCell,format the Header which is
created.
From run menu click on run.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Cognos Interview Questions

----------------------What are the User Securities?

0 Answers   IBM,


cognos is holap or molap or rolap

7 Answers   Cognizant,


What is the difference between a data mart and a data warehouse?

0 Answers  


Hi, I got a requirement wehre in in a drill through report , in parent report i have a column of numbers on which i have to apply drill through to child report.The condition is in that column if the number ia not zero the drill through link should appear (i.e., 1 to 9) if its 0 or negative number link should not appear. How ? Help would be appreciated

1 Answers   IBM,


please tell me architecture of the cognos8?

4 Answers   IBM, TCS,






how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.

4 Answers  


Hi..I have COG-112(Report Author),COG-122(Admin),COG-132(Meta data modelling). I took test end of Sep '09.I got 100% wcore with these dumps. If any body need then mail me on kris.bi121@gmail.com

2 Answers  


at what level u prepared the reports in cognos???? in dataware housing what is the automation tool u r using???

1 Answers   Covansys, IBM, Wipro,


where exactly determinants are used in cognos framework manager?

4 Answers   Satyam,


how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?

3 Answers   TCS, Thomson Reuters,


what is dimention?explain dimentable with example?

3 Answers   Syntel,


what is Galaxy schema??

2 Answers   IBM, iGate, Wipro,


Categories