I'm trying to create an embedded report that shows sales order history for only the current fiscal year. The only way I've been able to get the report to run correctly is by hard-coding the dates, but I'm trying to get away hard-coding. I've tried YEAR(invoice date) = YEAR(current_date), but this shows calendar year. I've also tried YEAR(Invoice Date) = valueof(NQ_SESSION.CURRENT_YEAR), but this pulls all dates b/c it is a session report.
Is all date fields in analytics mapped to custom fiscal years set by Oracle? And, if it does map, then can anyone give an example of case statement or function to try?