Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

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

Received Response
41
Views
5
Comments
Senthilkumar Subramaniam
Senthilkumar Subramaniam Rank 6 - Analytics & AI Lead
in Oracle Analytics Forum

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

  • Mohammed Rafi
    Mohammed Rafi Rank 4 - Community Specialist

    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
    Senthilkumar Subramaniam Rank 6 - Analytics & AI Lead
    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
    Carter Beaton Rank 4 - Community Specialist

    @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
    SteveF-Oracle Mod

    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
    Senthilkumar Subramaniam Rank 6 - Analytics & AI Lead

    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.