Dynamic Column Heading

Question

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

Avinash Pentyala · Answer

Hi Ebin,

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

Regards,

Avinash