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,

---

What are the different types of important services used in cognos?

0 Answers  

---

What is diffence between query calculation and layout calculation?

4 Answers  

---

Hi Friends, Just want to know, day to day is increasing or decreasing Cognos Usage in the Market? New Reporting tools to driving Reporting Market Spotfire, Tableau,Qlick View, some other New Tools. Which Reporting tool can generate Lot of Opportinities in the Market? Please Reply to this, My Advanced Thank to you. Thank You Kumar

2 Answers  

---

Which service handles requests for cognos connection,query studio and event studio.

3 Answers   HCL,

---

What is the size of the cube?

0 Answers  

---

---------------Describe OLAP Reporting and RDBMS Reporting?

0 Answers   Bank Of America,

---

How can we create a dynamic column name in cognos?

0 Answers  

---

Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!

1 Answers   Wipro,

---

can we join 2 different queries? One has 10 columns and other has 5+ columns?

2 Answers   IBM,

---

What is the concept of using Dimension allocation "By Measure"? How Transformer use when computing the Base measue?

0 Answers   IBM,

---

Name the types of report?

0 Answers  

---