This content has been marked as final. Show 3 replies
I'm not clear where you have created filter based on Source ID.1 person found this helpful
You may go with a new costum table with columns SourceID,Country
and join where ever you need to filter.
BTW: Source ID is different from DATASOURCE_NUM_ID?
If helps pls mark
Source ID is the same as DATASOURCE_NUM_ID .
We have created filter for all Reports and Dashboards. It is displayed on the prompt of all Dashboard Pages.
Hi all ,
I figured another Solution for this, I edited the Dashboard prompt and in the expresssion builder for prompt , I used
CASE WHEN SOURCE_ID=101 then 'Kuwait' END
However this is kind of hard coded , need to enable it each dahboard prompt.