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
Hi Senthil,
In classic OBIEE dashboards, prompts could directly leverage:
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.
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?
@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.
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.
Hi @Carter Beaton @SteveF-Oracle - Thanks for the response.
My scenario is to check or calculate the time measures to be dynamically calculating.
I will also check the shared videos above response. In classic , we have above scenarios in most of fusion Finance / Project based module reports.
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how these…
I'm trying to index a Local Subject Area so I can use it in my AI Agent, however, I keep receiving the generic error below. Request status(500) : error = {"prefix":"DSS","code":50000,"message":"There was an unexpected error while processing this request. Please try again."}
it is observed that in OAC while using case statements the output is not expected.For example if we have a case statment like case when table1.column1=table2.column1 then 'yes' else 'No' end as Attribute1 Now if i use this attribute with a fact-amount column attribute 1|| Amount on a report then we dont get the aggregation…
Once I select that value from the list box Region I created, I want to filter the table by my selection. See the images
Hi, While using OAS or OAC latest version can we generate a report to view complete defition of semantic model/subject area. It helps to document and troubleshoot. thanks
