15. If I select the current month and year how can we
display previous 11 months data?
Answer Posted / vamsidhar
A filter which filters the data for the last 11 months
should be defined.
The below filter with mior modifications will work...(I did
not try)...treating parmater1 as the prompt parameter
month_field between (parameter1-11) and (parameter1)..
U can also use addmonth function i.e addmonths(parameter1,-
11)
Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Which studio is used to create reports?
Define metrics studio?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
what is the procedure for scheduling conditional rendering?
What are the types of hierarchies?
Can we test the report other than manual testing?
Can you define drill down and drill up?
What do you mean by query studio?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
How can I schedule reports in cognos?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
----------------Describe DWH Architecture?
What is metric store database?