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

Emma W

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?

Many Thanks,

Emma

XML Calendar Year Headcount Time Basic Pivots.txt

RichardChan

Do you have a column in your date data for the academic year e.g. 23/24 you could then build your year hierarchy using this column rather than calendar year

Emma W

Thank you @RichardChan, unfortunately we only have calendar year, there is no academic year column. Do you have academic year in your otbi data data fields?