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 DISTNICT VARIABLES?

0 Answers  


Can you define dimension?

0 Answers  


cognos is holap or molap or rolap

7 Answers   Cognizant,


What is Online View?

0 Answers   IBM,


Are you aware of any limitations in Cognos?

1 Answers   HCL,






What are the different kinds of panes included in cognos?

0 Answers  


I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?

1 Answers   Cap Gemini, HSBC,


What are initial page components of Cognos connection?

0 Answers  


fiscal year means what???

8 Answers   iFlex, iGate,


what are ERP systems?

1 Answers  


what is the difference between filter and condition?

0 Answers   IBM,


can reportnet supports cubes???

4 Answers   IBM, Wipro,


Categories