1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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!

Question Posted / keyrun

Answer Posted / keyrun

Yes it is possible using Mapping Variable & Mapping parameters!

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you Parametermap variables in Quiries?

1778

Can you define transformer?

523

how to create measures and dimensions?

614

Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

914

Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4218




What junk dimension contains?

545

dumps needed ASAP for - C2020-180 Cognos IBM Certification

1820

Define query studio?

598

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

1553

Can we test the report other than manual testing?

1662

what is the difference between querystudio in reportnet and cognos8

1735

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

3203

How create measures and dimensions?

611

What is cognos powerhouse?

587

After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

1605