Prevmember Mdx Function Not Working
(Doc ID 2924984.1)
Last updated on FEBRUARY 03, 2023
Applies to:
Oracle Enterprise Performance Management FreeForm Cloud Service - Version N/A and laterInformation in this document applies to any platform.
Symptoms
Trying to use the "prevmember" mdx function on a member called "Prior Year" in the Scenario dimession.
The formula is below and should calculate/retrieve the prior year Actual data.
This validates but does not calculate.
([Actual],[Years].currentmember.prevmember)
I believer the issue is with the function because if I hardcode the year or use an essbase subvar the formula works.
See below.
([Actual],[FY21])
([Actual],&CurYrminus1)
Also tried the lag function and it can not get that to work either.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |