Run OTBI Report in previous Accounting Period

Vinod Kumar Mohanraj

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!

Nishanth B Jain

check this blog

https://www.rittmanmead.com/blog/2019/11/timestamp-functions-and-presentation-variables-in-oracle-cloud-analytics/

Vinod Kumar Mohanraj

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)