I have prompt date prompt (from and to), country and city,
how to get data from jan1/2012 to jan31-2012.
Answer Posted / 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 View All Answers
What are products of cognos?
Can you define confirmed dimension?
What is the use of powerhouse?
Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance
What is cognos powerhouse?
What is Metrics designer?
What is Fullouterjoin?
What is a Transformer?
How to create a cube in Transformer? What is the process? Please mention process thank u
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
Name the types of gateway?
Can you define cognos impromptu?
------------- How to identify the Revenue Column in Report?
what is catalog and types of catalogs in cagnos and which is better?
i was asked what are the caluclations done by you in your report? plz give reply