FILTER in the OTBI Analysis--> Performance Tile does not work, throws formula syntax error.
Summary
FILTER in the OTBI Analysis--> Performance Tile does not work, throws formula syntax error.Content
|
Hi All, I have formed the below query in BI Publisher Data Model that would return the 1st day of the current fiscal year (01-april). Any date I feed it, it will give me first day of that fiscal year. In BI publisher Data Model , Data Set, I am selecting source as 'OBI EE' and giving below query: ========================== SELECT CASE WHEN (timestampdiff(SQL_TSI_MONTH,timestampadd(sql_tsi_month,-month(current_date)+1,current_date),CURRENT_DATE) <= 3 ) THEN ( timestampadd(SQL_TSI_MONTH,3,(timestampadd(SQL_TSI_DAY,-DAYOFMONTH(timestampadd(SQL_TSI_MONTH,-MONTH(CURRENT_DATE)+1,CURRENT_DATE))+1, timestampadd(SQL_TSI_MONTH,-MONTH(CURRENT_DATE)+1,CURRENT_DATE))))) |
Tagged:
0