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

@ISATTRIBUTE("STORE") equivalent MDX function

Received Response
17
Views
7
Comments
edited Apr 18, 2021 3:11PM in Planning 7 comments

Content

We are trying to convert BSO member formulas to ASO, and we got stuck with @ISATTRIBUTE("STORE").

BSO formula: 

IF(@ISATTRIBUTE("STORE") AND  (@ismbr("Rephased Budget") OR @ismbr("OEP_Forecast")  OR @ismbr("OEP_Plan") OR @ismbr("OEP_Actual")))
"S100000" - "S110000" ;
ENDIF

ASO converted formula: 

IIF(
Is([Entity].CurrentMember,[STORE]) AND
Is([Scenario].CurrentMember,[Rephased Budget]) OR
Is([Scenario].CurrentMember,[OEP_Forecast]) OR
Is([Scenario].CurrentMember,[OEP_Plan]) OR
Is([Scenario].CurrentMember,[OEP_Actual]),
[S100000]-[S110000],[S160000]
)

But its not working as expected. I know we don't have this functionality in MDX to check

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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