Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 the use of layout component reference

3 Answers   Satyam,

Hi Buddies... i want to appear for cognos BI-Author certification. can anyone of you send me cognos latest dump. please help me.. cognoslalitha@gmail.com

4 Answers  

does query is created for date prompt?

9 Answers  

Actually we have 500 users when they run the report display the flage image related country user? How its possible?

0 Answers  

-------------What is a Conformed Dimension?

3 Answers   Bank Of America,

What is a dimension?

0 Answers  

how to merge 2 crosstabs thans

0 Answers   HCL,

Interval Prompt's Usage? Example for usage in Project

2 Answers   Cap Gemini,

what is view? types of views?

3 Answers   HCL,

What are the types of hierarchies?

0 Answers  

1. What is stiched Query 2. What is loop in Fm 3. Best practices in modeling in FM 4. Three types of SQL 5. Difference between pass-thro and native sql? 6. will usage of pass thro sql will improve the performance? 7. Complex problems fced in your project 8. performance tuning in reports

1 Answers   CTS,

How do you use SUM function in Reportnet?

3 Answers   IBM,

For more Cognos Interview Questions Click Here
Categories