@ISATTRIBUTE("STORE") equivalent MDX function
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
0