I have four region(Us, Uk, Canada, Europe) in my value
prompt. Along with this I want new prompt called All. Once
I click on All it should display all regions data. How can
I achieve this ?
Answer Posted / sriprabhath
Hi Nimmi,
Thank you for reply. I got u r answer making the prompt 'Optional'. But My requirement is that I want new prompt to be displayed in the value prompt called 'All' along with existing region prompts.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you define pivot?
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?
Can you define drill across?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What are the types of security?
How to publish a package by running Java Script?
What are all the different types of prompt in cognos?
What is looping and how to avoid it in framework manager?
What do you mean by drill through report?
Explain difference between powerplay transformer and power play reports?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
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.
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?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
hi friends pls forward impropmtu interview question