BI/Data Engineering Services Provider

OBIEE/OAS/OAC – Dynamic date calculations

Dynamic date calculations like first and last day of current/previous month, current/previous quarter and current/previous year and many other are required for default values in the dashboard prompts as well as in the report filters.

I often use below link for the required formulas and decided to share.

Oracle Business Intelligence: OBIEE How to use TIMESTAMPADD/TIMESTAMPDIFF for Date Time Period Calculation