Can someone tell me whether we can apply filter on list of
values in the 'Value Prompt'? e.g. I have a value prompt
(named city) and the prompting is holding around 2000
cities but I want to apply filters on cities so users can
select only 15 cities out of 2000 and then run the report.
Users should be flexible enought to select any 15 cities
from the list. Is it possible. Please advice!
- 5 Answers
- 8405 Views
- DELL, I also Faced
- E-Mail Answers
Answer Posted / sathish kumar
first you create value prompt as usual with parameter and applying the filter on city.
In the next step,you need to create the static choices to select the 15 cities among 2000.
And run your report..,
am sure you will definitively get the output.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can you define drill down and drill up?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
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
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
What actually a project contains?
How create measures and demensions?
What are all the types of report?
Can you define cognos decision stream?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
is there any difference between operational database and data base?if yes what r they?
What is the difference between ‘macro’ and ‘prompt?
How to a create header dynamically in a crosstab report in cognos 8.1?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
