1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

I have prompt date prompt (from and to), country and city,
how to get data from jan1/2012 to jan31-2012.

Question Posted / guest

Answers were Sorted based on User's Feedback



I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-..

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

Is This Answer Correct ?    8 Yes 1 No

I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-..

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.

Is This Answer Correct ?    0 Yes 7 No

Post New Answer

More Cognos Interview Questions

What is Lookup ,bridgeing tables where they will use in the Dataware house

2 Answers   IBM,

how many types of formats you can run a report using cognos?

4 Answers   HCL,

-------------What is Coditional Prompting?

0 Answers   IBM,

What is meant by Reportstudio shortcut?

0 Answers  

Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.

0 Answers  




my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

0 Answers  

can any body explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible.

8 Answers   Mind Tree,

What is Performance Tunning Test?

2 Answers   IBM,

In how many ways we can apply the security to a cube in Transformer? Explain?

1 Answers   Wipro,

what is the diffence between render variable & style variable with egs? Plz reply ASAP

4 Answers   TCS,

What is a query set?

3 Answers   IBM,

What is Regular Dimension and Measure Dimensions and Diff b/w them ?

2 Answers  

For more Cognos Interview Questions Click Here
Categories