Skip to Content

How to pass a Dynamic Default value in global filter in IDT 4.1 SP9

We have drop down filter to display in Dashboard for which we have created LOV and referring this in prompt definition using the @Prompt in the universe, which is working fine. But as per user requirement, I also need to display the last updated record as default value. e.g. the drop down is showing various product like A,B,C,D,E,…. ,and till this we are able to create in Universe and working fine in Dashboard. Now we need to show dynamically the latest product as default to be shown first and then rest of values suppose dynamically D is the latest product then the drop down will show D then A,B,C,D,E…

This product is coming from sql server database tbl_product with following fields productname, updated_date. Based on latest updated_date the corresponding product name need to be shown as default. As database get update for product information the latest product based on effect date will be shown dynamically as default.

So in nutshell how to refer this dynamic value in @prompt definition. Is there any approach to make this dynamic default value in global filter.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers