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.

How to do Performence Tunning in Cognos Reports?

0 Answers  

---

What is Outerjoin?

2 Answers  

---

how to create calculate column in report studio

4 Answers  

---

If you need latest cognos certification dumps to get certified in first attempt with 100% score, please e-mail to getmecert@yahoo.com

4 Answers  

---

Can you define set to be cardinality?

0 Answers  

---

What is value prompt limitations while creating report? What is select and search prompt?

1 Answers  

---

Define olap designer?

0 Answers  

---

What are the differences between cognos reportnet 1.1 report studio and cognos 8 report studio?

3 Answers  

---

-----------Types of Fact Tables?

6 Answers   Bank Of America, CTS,

---

Diff b/w Crossproduct and Outerjoin?

0 Answers   IBM, Mind Tree,

---

what is meant by roll up and roll back in dataware housing????

4 Answers   Covansys, IBM, Wipro,

---

I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD

1 Answers   L&T,

---