Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Reg: Hrs Metric for Difference Between two dates excluding weekends and Holidays

Received Response
1
Views
1
Comments
User_JZKI6
User_JZKI6 Rank 4 - Community Specialist
edited August 2024 in Oracle Analytics Cloud and Server

Hi Team,

How to calculate the Hrs metric for the Difference Between two dates for business Hrs (between 10 to 5 PM) also excluding weekends and Holidays in OBIEE reports .

Any suggestions/help for achieving this requirement OBI version we are using (12.2.1.4.0)

Regards,

Tagged:

Answers

  • [Deleted User]
    [Deleted User] Rank 5 - Community Champion

    Your time dimension should be modelled to include your notion of business days and business hours so that you can calculate this in a performant way.

    Business days and business hours aren't standardized, so no tool can do this for you automagically. Doing it in code with nasty CASE WHENs is horrible and extremely heavy in performance.

    The way to go is to already model your data accordingly so that every layer can simply resuse this in a performant way.