OTBI – To Date calculations (YTD/MTD/QTD)

OTBI does not support TODATE functions. Similar functionality is obtained by writing complex TIMESTAMPADD functions. In this post we provide, a set of date functions to calculate Year-to-date, Month-to-date, Quarter-to-date filters of any selected year, using only TIMESTAMPADD function.

Continue ReadingOTBI – To Date calculations (YTD/MTD/QTD)