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
10
Views
2
Comments
edited Dec 31, 2018 12:30PM in Essbase 2 comments

Summary

Need to have a 15 month view in ASO

Content

Hello,

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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