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.

Senthilkumar Subramaniam

Hi @Carter Beaton @SteveF-Oracle - Thanks for the response.

My scenario is to check or calculate the time measures to be dynamically calculating.

1. First to find or derive the time variable value in hidden prompt condition and to pass the same as a value to dashboard parameter selection. Ex: Year / Period for Trend based reports YTD/MTD/ITD/ITC
2. Then pass the selected year/period based selection to the report in the column logic derived in answers.

I will also check the shared videos above response. In classic , we have above scenarios in most of fusion Finance / Project based module reports.