How to get dynamic column names in the OTBI analysis

Sep 14, 2020 7:35AM

Summary

Hi,

We have a requirement were we need to display the column names(labels) dynamically.

THis report is about people who are hitting a major milestone in their career over next 12 months starting current month.

So I have 12 columns in the report for each month end date for next 12 months.

When I run the report in Sept-2020 month, The column names should be 30-09-2020, 31-10-2020, 30-11-2020, 31-12-2020 and so on till 31-Aug-2021.

When I run it in Oct-2020 month, The column names should be 31-10-2020, 30-11-2020, 31-12-2020 and so on till 30-Sep-2021.