Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Is it possible to make column names dynamic in DV

Received Response
291
Views
6
Comments
Amrita Gupta-Oracle
Amrita Gupta-Oracle Rank 6 - Analytics Lead
in Oracle Analytics Cloud and Server

Summary:

We have a requirement, where in a DV report displays the balance for the selected year, and, the previous year. And the selected year should be a part of the column name, as below -

Actuals 2022, Actuals 2021.

We attempted to do this with the DV variable plugin, but, that did not work. Is there any other way to achieve this.

Also, is making presentation variables available in DV on the roadmap. If yes, is there a timeline in place, which we can communicate with the client.

Content (required):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Answers

  • Federico Venturin
    Federico Venturin Rank 7 - Analytics Coach

    Hi @Amrita Gupta-Oracle ,

    It's not possible to make column names dynamic in DV at the moment, and I don't know whether making presentation variables available in DV is on the roadmap.

    As a workaround, you can use an analysis to make the column names dynamic. Analyses can be used to analyze datasets created in DV, moreover in a dashboard you can combine both analyses and DV workbooks and filter them all using dashboard prompts.

  • Amrita Gupta-Oracle
    Amrita Gupta-Oracle Rank 6 - Analytics Lead

    Hi @Federico Venturin,

    Thanks for your response. While it is possible in OAC Classic, we are looking to embed the visualizations in an Apex application. And DV visualizations work better for that. Hence looking for possibilities within DV itself.

  • Joshua C. Stewart
    Joshua C. Stewart Rank 5 - Community Champion

    Hi @Amrita Gupta-Oracle,

    I haven't tested the theory, but you might be able to leverage some of the functionality explained in this article to have APEX dynamically update the name of the column of the embedded analysis.


    You'll see a piece of the article where they're define a function to dynamically change an embedded visualization

    I imagine you could some function like the one below to dynamically set the Column Name/Formula.

    let sColName = apex.item("P7_DYNAMIC_YEAR").getValue();


    I just recently started playing with OAC Embedding in APEX and would be interested to see this work.


    Best,

    Josh

  • Amrita Gupta-Oracle
    Amrita Gupta-Oracle Rank 6 - Analytics Lead

    Thanks for the tip @Joshua C. Stewart. Will try it out, and, let you know how it goes.

  • Joshua C. Stewart
    Joshua C. Stewart Rank 5 - Community Champion

    @Amrita Gupta-Oracle - any luck with the proposed solution?

  • Amrita Gupta-Oracle
    Amrita Gupta-Oracle Rank 6 - Analytics Lead

    @Joshua C. Stewart,

    We have not been able to test it out as yet. It got pushed back due to some other priority tasks. Once i am able test it out, will let you know.