Can any one expalain the procedure for How to create a
Mastr Detail Report in Cognos 8.3 ver?
- 1 Answers
- 4460 Views
- I also Faced
- E-Mail Answers
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 |
How many number of cubes can we create on a single model? How can we navigate between those cubes?
How we check the errors before running the report,plz let me know the answer
What is Online View?
what is #prompt and #promptmany, runningtotal in report studio
If anybody need certification dumps like COG-112 COG-122 COG-132 THEN MAIL ME ON kris.bi121@gmail.com.all are latest dumps test taken on july-09
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 are the different ways of adding data in Transformer?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
can you apply grouping on crosstab?
Write some methods to apply securities in framework manager model?
how to connect datamarts
i am having a table having name cust_employee.i use this table in my model after i published that to cognos connection .i generate some reports. after that in my data base cust_employee table is changed to cust_emp.how can i get this table into my report.i again import and published means its time consuming,in simple how can get the changed table in to my model pls pls ans me....
Teradata 
