Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Decode value to pass to Prompt

Received Response
11
Views
2
Comments
Chandra M. G.
Chandra M. G. Rank 4 - Community Specialist
edited Aug 13, 2024 5:53PM in Oracle Analytics Cloud and Server

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.

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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
    Robert Angel Rank 8 - Analytics Strategist

    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!