Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Can I make an Academic Year 'Time' dimension in OTBI?
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
Answers
-
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
0 -
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?
0
