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 ?
Answers were Sorted based on User's Feedback
Answer / cognosvij
Hi Sriprabhath,
In your value prompt add the static chioce as 'All'
and in filter put the expression as....
(region column in (?Parameter1?)) or (?Parameter1?='All')
hope this may help u :)
vij
Is This Answer Correct ? | 14 Yes | 0 No |
Answer / ben
Hi vij,
Thank you so much for your answer! It was just the thing I
was looking for!
Ben
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / manish
You can also use page render with page1 with the region
filter and page2 with no filters.
Depending on the selection All the page2 will be displayed
else page 1 will be displayed with the filter
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
Answer / jaya
Go to the Query Explorer and click on the value prompt
expression and type 'in' in the place of '=' . When u run
the report , you will get the option 'show all' . let me
know when it works .
Is This Answer Correct ? | 0 Yes | 5 No |
Hi,
This is very simple to achieve.you can make your first
prompt an optional one. so if the user selects no options
in the dropw down then all the regions data is displayed .
if any region is selected then that regions data is
displayed.
hope this helps you..
cheers :)
Is This Answer Correct ? | 0 Yes | 7 No |
What are the components of report net?
How to generate cubes in cognos?
Explain the difference between native sql and cognos sql?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
How can we create regular dimensions & measure dimensions?
What is Stich Query in Reportnet?
------------------What is Focalpoint?
please please give me some banking calculations in framework manager.
There is any option to delete temp files automatically from temp directory in COGNOS? (without manual)
What is cognos connection?
Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?
How to pass parameter value into html design page? (That is YOU Create a html page and use that page in your cognos 8 report header.take <html item> my question is how to use parameter value in the html page .)