Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Financial Reporting Studio - prior years — 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

Financial Reporting Studio - prior years

Received Response
edited May 2, 2020 3:31AM in Reporting and Analytics for ERP 1 comment


Avoid hard coding year-end dates in reports


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

Howdy, Stranger!

Log In

To view full details, sign in.


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