SAP Knowledge Base Article - Public

3497065 - SAC Excel Add-in formula SAP.MEMBERPROPERTY returning #VALUE!

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

Product

SAP Analytics Cloud, add-in for Microsoft Office all versions