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!

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 can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

2797


What is Fullouterjoin?

1546


What is looping and how to avoid it in framework manager?

655


What is the function of model design accelerator?

533


What are the message flows?

553






Can you define framework manager?

616


What is meant by junk dimension?

559


i have one file i saved in csv how can i take these file into framework manager

1531


how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1483


------------------What is Inline Query?

1782


What are the advantages of cognos?

564


What is the difference between a cascading report and drill through report?

650


Cleared COG-112 with 100% score today. What next certification should i go for?

1411


--------------Diff b/w ODS and OLAP?

2750


What is dtm?

711