Parameterised Dates in OTBI — 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

Parameterised Dates in OTBI

edited Feb 4, 2019 10:12AM in Reporting and Analytics for HCM 5 comments

Summary

Need to get Tax year start and end dates relative to current date

Content

I need to get the UK tax year start date (April 6th) applicable to current date, the report needs to be scheduled overnight so must not require manual intervention to set the dates, otherwise it would be easy ;-)

In the good old days I would just have created repos variables, but here I only have OTBI, I have tried some overly complicated nested statements to extract the year based on current_date but that didn't work.

OTBI is still a learning curve for me, we appear to have Cloud HCM 19A (11.13.19.01.0)  and OTBI 11.1.1.9

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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