FILTER in the OTBI Analysis--> Performance Tile does not work, throws formula syntax error. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

FILTER in the OTBI Analysis--> Performance Tile does not work, throws formula syntax error.

edited May 29, 2018 7:12AM in Reporting and Analytics for HCM 2 comments

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)))))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!