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.

If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.

4 Answers   IBM,

---

difference between drill through and master detail report?

2 Answers   HCL, Zensar,

---

The vice president of sales has requested a report that shows sales performance by representatives in each country for year 1998. He would also like to see the performance for reprasentatives in Asia in order to present an award to the top sellers when he visits next month.

0 Answers  

---

drillthrough vs master detaild report,which one is the best by performance?

3 Answers   IBM,

---

You get a parsing error when you run a report. What will be your first steps to resolve the error?

2 Answers  

---

pls any body give the cognos 8 versions release year.

3 Answers  

---

Report studio has two SQL tabs one native SQL and another one cognos SQL which one is get more preference? which one we need to consider?

7 Answers   Blue Cross Blue Shield Association, TCS,

---

Define the slice and dice?

0 Answers  

---

I need your kind support. I have more than 6yrs of exp in s/w industry. I have worked on some DW technologies which are out dated. For almost 1 year I was on bench.During this bench period I learnt cognos on my own using online docs. Hence I am alligned to a project few months ago to work on cognos. Unfortunately after joining this project I did not get opportunity to work on cognos. I am working on different things apart from cognos. I should get job in another company. Otherwise I am gone. I am confident enough to get job on Cognos in another company. Please let me know is it possible to work on Cognos at lead position (as my current position is at lead level) without having real time experience. Your response is highly appreciated and I will be grateful to you. Thanks in advance Ganesh

2 Answers  

---

hi cognos Experts what are the enhancements in cognos 10 than cognos 8.4?Pls Ans Me........

1 Answers  

---

Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin

7 Answers   IBM,

---

What do you mean by drill through report?

0 Answers  

---