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 Column Heading

Received Response
1
Views
1
Comments
Ebin Cherian
Ebin Cherian Rank 5 - Community Champion
edited Aug 13, 2024 5:56PM in Oracle Analytics Cloud and Server

Hi,

Oracle Business Intelligence 12.2.1.1.0

I am using a session variable to populate a column heading in OBIEE. I use the command @{biServer.variables['NQ_SESSION.Cal']} in the column heading. Variable returns the value in format 2017-September. I need to just display September in the column heading. We could create a new variable in the required format and use it. But I am looking for something quick before doing the next rpd push. Please let me know how to format value from the variable.

Thanks

Ebin

Answers

  • Avinash Pentyala
    Avinash Pentyala Rank 5 - Community Champion

    Hi Ebin,

    Yes, You have to create a new variable. or use TO_DATE functions to change the existing format.

    Regards,

    Avinash