Symptom
Your SAP.MEMBERPROPERTY formula using "Description" as the Property parameter now returns #VALUE!, when it used to work before.
Environment
SAP Analytics Cloud, add-in for Microsoft Office
Reproducing the Issue
You have a formula similar to the below that used to work, but now returns #VALUE!:
SAP.MEMBERPROPERTY("Table", "<Dimension>", "<DimensionMember>", "Description")
Cause
Change in SAC Excel Add-in.
Previously, in the "Set Properties" dialog, property id and property description were translated based on the application language. After the change, these are now translated based on data language (like in SAC Excel add-in table). So, users with different application and data languages in SAC Excel add-in can get the error message above with SAP.MEMBERPROPERTY formulas.
Resolution
To solve your current issue, we strongly recommend you to update your SAP.MEMBERPROPERTY formulas by using the exact property ID instead of the property description (both available in the "Set Properties" dialog).
You can still use property description (the one shown in the "Set Properties" dialog will work) but be aware that the property description is user language dependent so SAP.MEMBERPROPERTY formulas relying on property description will not work for all users working in different languages.
Be aware that property ID is case sensitive while property description is not.
Keywords
KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Product Enhancement