Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10344 Views
- DELL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / keyrun
Yes it is possible using Mapping Variable & Mapping parameters!
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / 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 |
What is limited local? and the uses?
What is Portal Tab?
What is the difference between drill down and drill through?
10 Answers DELL, Deloitte, Systime,
what is tabular set? how can you break the report?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
what is mean of Meta data definistions?
What are the different types of OLAP. Which one is Cognos Powercube?
What are the different type of securities can we apply in framework manager?
In Drill through, Reports are executing successfully when rename & run the created reports? Pls tel me the reason?
Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?
what is catalog and types of catalogs in cagnos and which is better?
How the Bursting happens in same report and how to Print the bursting Report?
Teradata 
