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 |
What is the function of model design accelerator?
Write some methods to apply securities in framework manager model?
Can you define a datastore in cognos?
HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS
5 Answers IBM, Virtusa, Wipro,
What is main advantage datawarehousing over oracle?
what is the difference between rollup aggregation and aggregation ?
how can you get the errors in job? when loops are araised we get error?
how to change the colour of the bar in charts...?
What are the main services provided by application tier?
What are the types of hierarchies?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
what is report studiio and how to start it?