ASO Dynamic Calc member formula issue after April update
We have a Account dynamic calc member with below formula for ASO, which worked fine before April update and now we are facing issue with SmartView retrieval because of this:
IIF(ISANCESTOR([Entity].CurrentMember,E1XX,INCLUDEMEMBER), // This will run for EXXX, EXX1, E1X8, E1XX
[AA9X291]-[A2X15],
0)
I have tried modifying it like below but still seeing the issue. Did any see something like this in your applications.
CASE WHEN [Entity].CurrentMember IS [Entity].[EXXX]
OR [Entity].CurrentMember IS [Entity].[EXX1]
OR [Entity].CurrentMember IS [Entity].[E1X8]
OR [Entity].CurrentMember IS [Entity].[E1XX]
Tagged:
0