how can you restrict the number of values available for a
prompt?
i tried this by using static choices property, but i dint
get result... so pls explain in detail steps....

Answer Posted / chandra

when you create prompt report studio create a separate query
for that prompt. in this query write the filter condition.
It will filter the prompt values in prompt.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between filter and condition?

597


how to perform single sign in cognos by using url?

560


Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

3145


Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

1640


what is power prompt in cognos ep7series?what is the use of this?

3197






-----------------What is Direct and Conventional loading?

1641


What are the advantages of cognos?

563


What is defined as catalog and types of catalogs in Cognos?

561


What is the difference between set functions and filter function in dimensional data?

2504


How do we drill through from a powerplay cube to reportnet?\

1880


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

3913


What is the deployment requirements used in cognos?

540


What are the types of security?

534


Which studio is used to create reports?

596


4. How many dimensions did you use in your reports?

1489