Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 282 Oracle Analytics and AI News
- 59 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Possibility to have classic features of Prompts - Hidden variables / Repository var in SQL
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
Answers
-
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.
0 -
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?
0 -
@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.
0 -
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.
0
