suppose a value prompt contains 100 values and i want to
select all values in that prompt....i want ALL option in
the value prompt? how can u keep this option in value
prompt?

Answer Posted / vij

hi Vijay,


In your value prompt add the static chioce as 'All'
and in filter put the expression as....

(column in (?Parameter1?)) or (?Parameter1?='All')


hope this may help u :)
vij

Is This Answer Correct ?    16 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

581


What are various types of gateways in cognos?

541


Write various indexes used in cognos?

552


What is the use of Cognos scenario?

720


hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

1772






What do you understand by the term 'aggregate advisor?'

537


I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

1525


Explain the characteristics of cognos?

607


Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com

1617


What are all the types of indexes in Cognos?

710


if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1528


-----------------What is Determination Model?

1689


What is the function of cognos dispatcher?

588


What are the steps to import the two data sources in framework manager?

614


What is model filter?

626