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
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?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
what is hints in cognos and where we use it.
What is model?
What are the themes in a data warehouse?
What is the difference between static and dynamic conditions?
-----------------What is Determination Model?
What do you understand by user class in cognos?
What is the size of the cube?
how to test reports in cognos?
what is the main advantage of impromptu over cognos reportnet?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
What are the other methods working as deployment functionality?
------------------What is Inline Query?