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

ASO Dynamic Calc member formula issue after April update

edited May 11, 2026 3:19PM in Planning 5 comments

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]

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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