My Oracle Support Banner

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 later
Information in this document applies to any platform.


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.


I believer the issue is with the function because if I hardcode the year or use an essbase subvar the formula works.
See below.


Also tried the lag function and it can not get that to work either.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.