15. If I select the current month and year how can we
display previous 11 months data?
Answer Posted / revanth reddy
for example emp table i am telling
hiredate=add_months(sysdate,-11) from emp
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
hi friends pls forward impropmtu interview question
How do you improve the performance of the Cognos Analytics report
What you mean by drill across and what is the difference between drill through, drill across?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
What are all the types of gateway used in Cognos?
What is the difference b/w macros and prompt?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What errors and types of errors you faced in Cognos ReportNet?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
How do you call a store procedure within a transformation?
What is cognos powerhouse?
Can you define query studio?