Answer / nagendra

create a filter in the report Query with date from and date
to parameters.
eg: date>=paramdatefrom and date<=paramdateto
When you run the report Select date prompt from jan 1 to jan
31 2012

Answer / srini madhala

For example if you are in Mar2012:-

_add_months(sysdate,-2) which takes you into Jan2012.
After this convert the _add_months(sysdate,-2) to t0_char or to_date as required.

What is Correlated sub-query? Please explain

1 Answers   Target,

---

What is dtm?

1 Answers  

---

What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

1 Answers  

---

Explain how data modeling is useful to cognos in daily life?

2 Answers  

---

I have 3 dataitems in a list username,transaction type,transaction amount. In transaction type i have 3 types 'add','update','delete', i have almost 750 rows. After displaying the list report i want to know no. of add's,update's,delete's in 3 different rows

2 Answers  

---

1)How to bursting the cross tab report? 2)What is meant by Object explorer? 3)What is cascade report?

1 Answers   IBM,

---

3. What was the size of your cube?

1 Answers   IBM,

---

how to improve the report performance?

1 Answers  

---

Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??

2 Answers   Barclays,

---

-------------How to do Bursting a Report?

1 Answers   Cap Gemini,

---

------Diff B/W DrillThrough and master and Detailed Report?

2 Answers   IBM,

---

what is render variable

5 Answers   Accenture, Cap Gemini, Systime, TCS,

---