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

Can I make an Academic Year 'Time' dimension in OTBI?

in Reporting and Analytics for HCM 1 comment

Asking for a colleague

Hi all,

I need to show workforce trends over time by Academic Year e.g. 2023/24 = 1 September 2023-31 August 2024.

I have successfully made time series (calendar year, month) Headcount reports using the Workforce Management - Workforce Trend Real Time subject

area columns/fields in the 'Time' and 'Workforce Trend' folders. XML attached.

However, I need to show trends by Academic Year and cannot work out the logic to group particular months from 2 calendar years; the 2023/24 academic year would span 2 years e.g. 1 September 2023- 31 August 2024; the 2022/23 academic year would span 1 Sept 2022 - 31 Aug 2023 etc.

Has anyone had a similar issue or are able to advise?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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