Decode value to pass to Prompt

Chandra M. G.

Hello,

I have a dashboard prompt (Column Prompt) which is fetching values from database & putted some case statement to short and meaningful value. Now its showing values in drop-down as per my case statement.

Now in Analysis, i am taking that prompt value with "As Prompted" condition so when same value (Modify by case statement) pass to that prompt then it doesn't filter data because same filter not exist originally.

So in this case how can i decode those values again & pass to that analysis so that it can filter as per database value.

Please suggest.

Thanks

Chandra M.

Robert Angel

Hi, just apply the same logic to the underlying column as a function column that you is prompted is on, but change it to be based on a presentation variable, populating the presentation variable from your original prompt.

Note also you do not have to display the column.

Robert Angel

Btw - best is get your ETL / DW team to do what you are doing, so all of the pre-processing logic is where it should really be, and your BI remains clean and performant!