Filtering Value Prompt

[Kid_in_Cognos]

Hi

I want to filter the value prompt based on the data.

say, i have prompt which is having 15 countries. The value prompt should display only the countries which is having data.

Like if there are India, USA, Uk are in the file.
Suppose,UK does not have data, the user only has to see the India and USA only in the prompt.

Can you guide me how to do it?

Thanks

[bdbits]

Define "have data". You will need to modify the query which populates the value prompt to only include the rows that "have data", however you define that.

[Kid_in_Cognos]

Hi bdbits

I am still not clear. I could not able to find "have data" option.

can you explain me in more detail?

Thanks

[Kid_in_Cognos]

Hi
I want to filter the value prompt based on the data.

say, i have prompt which is having 15 countries. The value prompt should display only the countries which is having data.

Like if there are India, USA, Uk are in the file.
Suppose,UK does not have data, the user only has to see the India and USA only in the prompt.

Is it possible to do? If so, Can you guide me how to do it?

Thanks

[MFGF]

Hi
I want to filter the value prompt based on the data.

say, i have prompt which is having 15 countries. The value prompt should display only the countries which is having data.

Like if there are India, USA, Uk are in the file.
Suppose,UK does not have data, the user only has to see the India and USA only in the prompt.

Can you guide me how to do it?

Thanks

Hi,

Can you define exactly what you mean by "UK does not have data"?

The approach to take is to filter the query that delivers the prompt values, but unless you can be specific about how to implement the "does not have data" filter, it's not really possible to guide you with any more detail...

MF.

[MFGF]

Hi bdbits

I am still not clear. I could not able to find "have data" option.

can you explain me in more detail?

Thanks

Why have you posted the same question in two threads?

http://www.cognoise.com/index.php/topic,30514.0.html

Please read the forum etiquette post, paying particular attention to point 4:

http://www.cognoise.com/index.php/topic,24030.0.html

MF.

[Kid_in_Cognos]

Hi MF,

Please find the below scenerio

country    company    revenue
---------   ----------    --------- 
Ind          abc            5000
Aus          xyz            6000
UK                                   
USA         ms             7000


The above table does not have data for UK.

MY scenerio is , I have the value prompt for Country.

is it possible to show the value prompt to the user, only the countries which are having data?
in the above case ,when the user select the prompt,he has to see only Ind,Aus and USA.   And he should not see UK in the prompt, as it is not having data. is it possible?

Am I clear atleast this time?

[Kid_in_Cognos]

Kindly remove this topic from Cognos 8 thread as Cognos 10 report studio was not working yesterday, i updated here.

Thanks

[HalfBloodPrince]

Add revenue column in prompt query and put filter as  Revenue > 0

[MFGF]

Kindly remove this topic from Cognos 8 thread as Cognos 10 report studio was not working yesterday, i updated here.

Thanks

I have merged the two threads so you don't lose responses from either.

MF.

[venkatesham2132]

Put filter in prompt query as company is not null then run the report

Sent from my GT-N8000 using Tapatalk