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
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
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.