Answer / shree uday

Create a catalog with .cat file...

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,

---

Can you define materialized view?

0 Answers  

---

Can any body suggest me that Drill through of packages is possible? If yes, how it can be done?

1 Answers  

---

How can we improve performance in report studio level?

1 Answers  

---

It is possible with out same Queries(both Reports) we can build the drilltrough between them? and how?

1 Answers   HCL,

---

Give me any example of semi and non additive measures?

0 Answers  

---

What is Performance Tunning Test?

2 Answers   IBM,

---

if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

0 Answers  

---

we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance....

1 Answers   IBM,

---

how to improve the report performance?

1 Answers  

---

what is cube size?

4 Answers   IBM,

---

wHAI IS THE DIFFERENCE BETWEEN LIST REPORT AND CROSSTAB REPORT?

7 Answers  

---