You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

How to get dynamic column names in the OTBI analysis

edited Sep 14, 2020 7:36AM in Reporting and Analytics for HCM 3 comments

Summary

How to get dynamic column names in the OTBI analysis

Content

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!