Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Alternate View — 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

Alternate View

Accepted answer
edited Dec 31, 2018 12:30PM in Essbase 2 comments


Need to have a 15 month view in ASO



We are trying to create a 15 month view (i.e. March 2019 will be Jan-Dec 2018 + Jan-Mar 2019) in an ASO application (this is EPMA). First I want to get the Jan-Dec 2018 component working, so in the view dimension I have a member with the formula:

CASE WHEN IS ([Period].CurrentMember, [MAR]) THEN SUM(PeriodsToDate([Period].Generations(1), [Period].[Dec]), [View].[Periodic], [Year].CurrentMember.PrevMember) END

It does not work, however if I take off '[Year].CurrentMember.PrevMember', it works for the current year. I make the ASO formula just '[FY18]', it also doesn't work. Are there any limitations to referencing years in ASO member formulas?


Howdy, Stranger!

Log In

To view full details, sign in.


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