@MDSHIFT Function Using A Member As Parameter Returns Error
(Doc ID 2582901.1)
Last updated on SEPTEMBER 23, 2019
Applies to:Hyperion Planning - Version 18.104.22.168.008 and later
Information in this document applies to any platform.
@MDSHIFT function using a member as parameter returns error
After a recent EPM patching to 22.214.171.124.008 Planning PSU, noticed that @MDSHIFT function generates an error at running time, when using a member as a parameter instead a hard coded number (however it validates in Calculation Manager):
Using this does not work anymore:
@MDSHIFT("Closing_Balance", "PriorMonthYearIndex", Years, ,"PriorMonthPeriodIndex", Period,)
NOTE: PriorMonthYearIndex and PriorMonthPeriodIndex are Dynamic Calc Accounts.
These are used to avoid "hardcoding the parameters"... For example:
@MDSHIFT("Closing_Balance", -1, Years, ,-1, Period,)
Error [executing] formula for [Data] (line : 19), use integer e.g. -1, 0, 1, 2.. as shiftCnt arg in @MDSHIFT function
Recent Planning Patch upgrade to 126.96.36.199.008
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