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



I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt c..

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

I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt c..

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

I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt c..

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

I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt c..

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

I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt c..

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

I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt c..

Answer / nimmi

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

Post New Answer

More Cognos Interview Questions

What are the components of report net?

0 Answers  


How to generate cubes in cognos?

0 Answers  


Explain the difference between native sql and cognos sql?

0 Answers  


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

0 Answers   TCS,


How can we create regular dimensions & measure dimensions?

2 Answers  






What is Stich Query in Reportnet?

10 Answers  


------------------What is Focalpoint?

1 Answers  


please please give me some banking calculations in framework manager.

0 Answers  


There is any option to delete temp files automatically from temp directory in COGNOS? (without manual)

1 Answers   CTS, IBM,


What is cognos connection?

0 Answers  


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?

5 Answers   Mphasis,


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 .)

4 Answers   JKL, Kudos India,


Categories