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

Dynamic headers in OAC classics report

Received Response
425
Views
13
Comments
2»

Answers

  • Bharath Raghupathi-Oracle
    Bharath Raghupathi-Oracle Rank 4 - Community Specialist

    Hi Indra,

    For some reason if you are unable to use repository variables. You can consider below solution as well.

    • Create a union report in OAC Classic
    • First union report you can setup the dynamic values what you are expecting for Headers.
    • Second union block can be actual data to be shown in the report
    • Disable Table heading, setup a sort column to get the header as first row of the table

    Examples as below






  • Indra Sardana-Oracle
    Indra Sardana-Oracle Rank 5 - Community Champion

    Gianni Ceresa ,

    Thanks for correcting me, I have changed now.

  • Indra Sardana-Oracle
    Indra Sardana-Oracle Rank 5 - Community Champion

    Thanks Bharath, but as explained due to mismatch of data type number and varchar for header we can't use union of reports and we used session/repository variable.

    Regards

    Indra Sardana