Missing Overall Feedback and Max Questionnaire Score in OTBI
we have a business requirement to report the Overall Feedback Score for each feedback provided in Oracle Recruiting Cloud using OTBI.
We explored the available subject areas and attributes in OTBI to check if there is any direct attribute that returns the Overall Feedback Score, but we were unable to find one.
As an alternative approach, we attempted to derive the Overall Feedback Score using a calculated metric based on questionnaire responses. The intended calculation is:
Overall Feedback Percentage = (SUM of individual feedback question responses × 100) / Maximum Questionnaire Score
While we are able to fetch the individual question responses and calculate their total, we are unable to locate or fetch the
Tagged:
0