In which subject area can I find Last working day in OTBI

Femilas B-Oracle

Nathan CCC

Hi, Most all subject areas have a time day dimension. If by working day you mean not a Sat or Sun then you can add a function to filter out only days in the week based on day of the week number. To get last then you can use a aggregate function to get max/greatest or min/least. But if you have configured public holidays in calendar events then I think these are not in the time dimensions in any of the subject areas unfortunately.

For more information read your user guide

Oracle® Fusion Middleware

Logical SQL Reference Guide for Oracle Business Intelligence Enterprise Edition

Release 12c (12.2.1.3.0) E80604-01 August 2017

https://docs.oracle.com/middleware/12213/biee/BIESQ/toc.htm

DAYOFWEEK

The DAYOFWEEK function returns a number between 1 and 7 corresponding to the day of the week, Sunday through Saturday, for a specified date. For example, the DAYOFWEEK function returns a number 1 to correspond to Sunday, and the number 7 to correspond to Saturday.

LAST

The LAST function selects the last non-null value of the expression. Do not use the LAST function when you need to compute the last value based on the chronological key rather than the primary level key, or if you need to return the last value regardless of whether it is null. Instead, use the LAST_PERIOD function. See LAST_PERIOD.