How to Add a dynamically changing column header based on the year (ex. 20XX)
For my BI Publisher report I need to have a column heading (not the report header) change based on the year returned by my SQL statement.
Example: the column header was hard coded in the past as 2018, then 2019 now 2020.
My modification needs to eliminate the hard code and dynamically change the last 2 digits of the year to 2021 when the report executes beginning 1/1/2021.
What do I need to do to make the last 2 bytes of the year dynamic? (ex. 20XX), as stated the year is returned by my SQL statement in the Data Model.
We have BI Publisher version 12C.
Thank you,