Categories
- All Categories
- Oracle Analytics Learning Hub
- 25 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 234 Oracle Analytics News
- 45 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Cross subject area Calculation columns
I'm building a learning dashboard using two subject areas: HCM Learning (for course completion) and HCM Workforce (for headcount). I'm struggling to calculate compliance % because headcount is an out-of-the-box KPI with unclear logic, and it's not a conformed dimension in the Learning subject area. This causes inconsistent figures when I try to use it there. Any suggestions on how to accurately compare KPIs across subject areas, especially for compliance reporting?
Answers
-
Hello @User_MFUYU,
This can be challenging. First, you need to ensure the statistical attributes are calculated at the correct grain as documented in the Report Authoring Tips documented here:
Hope that helps get you started.
Regards,
John
0 -
As you have mentioned, it is not easy to get out of because both Subject Areas - HCM Learning (for course completion) and HCM Workforce (for headcount) have no connection with each other.
You might need to consider BIP datasets and see if it can get you what you need.
0
