Clarification on using Descriptor ID feature

Question

Hi

In a dashboard prompt for one of the fields am displaying the description and passing the corresponding code into the analysis as filter. The column used to pass the dashboard prompt is marked as 'is prompted' and the sql query is passing the code of the selected description into the report which is working as expected,

But the same field (the one with descriptor ID)  is used as a Limit Values By field for another column, even here only the code is getting passed, is there any workaround to pass the description within the prompt instead of passing the code.

Thanks

User_28Q0J · Answer

Lets say there are 2 columns, one with descriptor id and one without, and am using the one without in the dashboard prompt and using Limit Values By. Now the description will be passed to other prompt fields where Limit By is enabled

But, when we use the one with descriptor id in the anlaysis filter as 'is prompted' will it still work, I tried doing it but the values are not passing

Joel Acha · Answer

You could duplicate the column in the repository and exclude the descriptor ID from the duplicate.