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
- 8849 Views
- DELL, I also Faced
- E-Mail Answers
Answer Posted / sreenivasulu pokuru
Step1:take a list report with country column.
step2:create a value prompt based on country.
step3:go to query explorer
step4: select query-2 based on value prompt.
step5: drag country query item into detailed filter.
step6: write a filter condition like(country in
'india','china',............)
step7:run the report
Diffenetly u will get what requirement u have to do.
Thanks & regards
Sreenivasulu pokuru
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
explain how to create powerplay reports?
What is difference between informatica power mart and power center?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
What is the difference between drill through, drill across?
What are the other methods working as deployment functionality?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
What do you understand by ‘ibm predictive maintenance and quality’?
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
what is hints in cognos and where we use it.
---------------Describe OLAP Reporting and RDBMS Reporting?
Tell me about Dnamic and Static Dashboards?
What are the components used in web tier?
What are the considerations regarding performance kept in mind while setting up cognos?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate
