Thanks Giri, another sensible suggestion and I agree it gets very messy trying to code it, but since we have no real autonomy over the physical tables in SaaS (other than enabling various flexfields) the question lies in where/how we can create this flag against a calendar table. In the HCM subject areas of OTBI, for…

Hi Rick, Thanks for your comments. In your case, did you end up building a report in BI Publisher that pointed directly at the physical table in JDE or were you able to model (or map) the Work Day Calendar table into your OBI/OTBI subject area? Within what tool did you end-up building your analyses? Thanks, Richard

Hi Thomas, Thanks for your comments. Agreed, so the approach is finding that calendar in Fusion and forming the calendar appropriately in the application. The challenge is getting that calendar mapped into our OTBI subject areas, from a SaaS environment, where we have no access to an RPD. Thanks, Richard

Hi Gianni, Well yes public holidays are different per country, clearly, but it was more reference to whether we could use any exposed out-the-box date fields in OBIEE/OTBI (sourced from the Fusion ERP application) and use them in an Answers formula. Hard coding public holidays over the next n years in a BI Answers formula…