Run OTBI Report in previous Accounting Period
Summary
Run OTBI period in previous Accounting Period
Content
I have a OTBI Report with Accounting Period as input parameter.
Requirement is to run the report for current and previous accounting period. For example, If the input is Dec 19, then the report should for Dec 19 and Nov 19. How do we achieve this in the filters?
Your inputs are highly appreciated.
Thank you!
0
Comments
-
Thank you Nishant!
I am facing issue in converting string to date using CAST function. This syntax throwing error. Appreciate your inputs.
CAST(CONCAT('1-','Apr-19') AS DATE)
0
