Dynamic Column Heading

Ebin Cherian

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

Hi Ebin,

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

Regards,

Avinash