Possibility to have classic features of Prompts - Hidden variables / Repository var in SQL

Senthilkumar Subramaniam

Hi

What are the chances of bringing options for hidden variables , make it similar classic options in terms of prompt sections with dynamic variables/request variables/ repository / session variables use in the prompts.

Thanks,

Senthil

Mohammed Rafi

Hi Senthil,

In classic OBIEE dashboards, prompts could directly leverage:

• Repository variables
• Session variables
• Presentation variables (including hidden prompts)
• Request variables
  and you could chain them pretty freely inside prompt sections.

In modern Oracle Analytics (OAC / DV), the architecture is different. Prompts are more UI-driven and less tightly coupled to variables in the same explicit way.

Senthilkumar Subramaniam

https://community.oracle.com/products/oracleanalytics/discussion/comment/74893#Comment_74893

Hi @Mohammed Rafi - Thanks for the response. Quick question, is there a possibility to have hidden variable logic checks and use them in prompts like classic? Any alternate way to use that in OAC DV side?

Carter Beaton

@Senthilkumar Subramaniam Can you give a more specific example. I ask because DV prompt can utilize parameters and they are pretty powerful. They can reference Request variables, session variable and can be nested. I added a couple of videos for reference if you have not seen them. I have used all techniques above in dashboards builds. I would be interested in what specifically you looking for. If it's not possible currently maybe you can post it as an idea in the Idea Lab.

https://www.youtube.com/watch?v=2HYoKRe2LWo

https://www.youtube.com/watch?v=LSLgmMzYp-E

https://www.youtube.com/watch?v=a0RacJu4Skc

SteveF-Oracle

You can use parameters within calculation logic (such as CASE WHEN) to show/hide specific data) with a filter bar prompt. Simple example, show fixed costs vs. variable costs. I am not sure if that is what you are looking for.