Interested to Buy Any Domain ? << Click Here >> for more details...
15. If I select the current month and year how can we
display previous 11 months data?
- 2 Answers
- 10074 Views
- TCS, I also Faced
- E-Mail Answers
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
Can you define snapshot?
What is Bitmap Index?
10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?
How we check the errors before running the report?
What is the difference between ‘macro’ and ‘prompt?
What is the enterprise class platform architecture of cognos 8?
How can we create a dynamic column name in cognos?
What are slice and dice?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
What is meant by alternate drill down with ex?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
---------------Describe OLAP Reporting and RDBMS Reporting?
how you create security to reports?
What are the considerations regarding performance kept in mind while setting up cognos?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
