filter on prompt

[anilkumar]

hi

how do  filter on prompt
for eg: i have tree prompt which contains five countrie
but i wanto show only tw0 countries in the prompt

dimensional data cubes are using as data source

please help

Regards
ANIL K.MARRI

[lindero]

you must create a query which retreives only the two countries from the datasource. Then you have to connect the pormpt with this query.

cheers

[ydeliwala]

To simplify what lindero suggested

If you already have the prompt created along with its query. Open that query and add a filter to include only the countries you want to include.