1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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 ?

Question Posted / sriprabhath

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 is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

0 Answers  

Please explain the different stages in creating a report in cognos report net?

0 Answers  

What is the difference between macro & Parameter

1 Answers   IBM,

How can i approach to write Congnos Certification? What exactly should i do? Can anyone guide me plz?

1 Answers   Polaris,

How can we improve performance in framework manager level?

3 Answers   Wipro,




How to create a Ratio in Cognos Report studio Reports?

1 Answers   IBM,

what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

0 Answers  

What are all the different types of prompt in cognos?

0 Answers  

What is TRAP in Framework manager?What's the use of TRAP? Where We are using this?

2 Answers   HCL, TCS,

What is called a slice?

0 Answers  

Where do i get Free COGNOS 8 Certification Dumps Downloaded for these codes COG-105, COG-112, COG-122, COG-125, COG-132, COG-135, COG- 142, COG-145, COG-180, COG-200, COG-205, COG-300, COG-310, COG-400, COG-480

7 Answers  

What are the uses of query explorer? Give example for each use in detail. It is not given clearly in user guide so explain in detail.

1 Answers  

For more Cognos Interview Questions Click Here
Categories