Guidance to optimize OTBI HCM Cross-SA Reports having static report filters
1- Some Cross subject area reports may be costly in terms of response time, if they are not designed correctly. It is always recommended to use (i) at least one common dimension, (ii) at least one measure from each of the participating subject area, (iii) some filters on common dimension attributes for cross subject area OTBI reports.
2- In addition to the above three recommendations, we would also like to share one technique that could help improve the performance of the cross subject area reports.
3- This technique (i) encapsulates the report-filtering logic in a dashboard prompt that generates a list of desired assignment_id values and then (ii) executes the cross subject area report for these specific assignment_id values.