Oracle Fusion ERP Analytics

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

Dynamic column names and column value for BI report

73
Views
2
Comments

I am creating custom report, in that we have to get column names and their respective values dynamically.

image.png

Like this I have data, I have to get output like in this format.

image.png

Please can someone help me on this.

Comments

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

    we can achieve custom column header using variables.Can you elobrate the scenario on basis of what these values will change dynamically.

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics & AI Strategist

    Hi @Rahul K-Oracle

    As per your question, you are planning to develop an Pivot table report instead of table view (xls output). you can provide more details about your test case to suggest further.

    Regards,

    Arjun