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,

---

how to Explain a complex report at the time of interview ? please post the answer very urgent?

3 Answers   HSBC, IBM, TCS,

---

What is Clipboard? How to import XML file into Clipboard?

2 Answers   CSC, HCL,

---

Can you define a datastore in cognos?

0 Answers  

---

my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

1 Answers  

---

what are typees of dimensions

11 Answers   HCL,

---

In Report page i have three types like (List,Cross tab,Chart), using Conditional Block i need only type of Report (Chart)at run time.How to do this I need The Complete Steps to do this?

1 Answers  

---

i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?

1 Answers   JPMorgan Chase,

---

What's the differance between each studio in cognos 8?

1 Answers   TCS,

---

How many fact tables you have in your project?

1 Answers   HCL,

---

Explain about embedded & standalone filters?difference between them

1 Answers  

---

Hi is any one having link to download books on datawarehouse tool kit by ralph kimball or any other authors books.

5 Answers  

---