Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Financial Reporting Studio - prior years

edited Nov 6, 2023 3:59PM in General Ledger & Intercompany 3 comments

Summary

Avoid hard coding year-end dates in reports

Content

I am using Financial Reporting Studio with an Oracle Essbase connection and require dynamic date reporting so that prior years are not hard coded into reports. In my previous system, i used Web Studio and i could use both the YEAR and MONTH dimension because they were split out separately: "Relative to Current Year - 1" for YEAR and then for the PERIOD/MONTH dimension: hard code March as the month; for the prior fiscal year numbers to pull in, dynamic based on year, but always year end (March). I cannot find how to use this since the Period and Year

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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