Refreshing dynamic column headers along with data
I have written a faceted report for actuals v. budget for up to the last years, including current year[CY].
facets include department, period_year and period_num[month]. rows are by period_num
I dont want to hard code the column headers, so using dynamic column headers so the reports would auto-update as years change — for column headers
so i created page items for each year e.g:
P34_CY has attached sql: select extract(year from sysdate) from dual
p_34_CY1: select extract(year from sysdate) - 1 from dual and so on…
the column headers label will be defined as: &p34_CY. YTD_NET, &p34_CY1. YTD_NET…