SAC Excel MEMERPROPERTY not returning Description

[bldr]

I have a number of Excel files setup using the SAP.MEMBERPROPERTY function to label rows and columns.
Today I am finding that previously working cells now give me a #VALUE! error in Excel with the SAC Excel Add-in.

For example:
=SAP.MEMBERPROPERTY(DS_1, "Measures", "qty_u", "Description")
This used to return the Description of my measure "Unit Qty" - today I get #VALUE!
=SAP.MEMBERPROPERTY(DS_1, "Measures", "qty_u", "Name")
Still returns "qty_u" as it previously did

=SAP.MEMBERPROPERTY(DS_1, "Version", "public.2024FC", "firstPlanDate")
works and returns my custom property as defined in the dimension tables in the modeler

=SAP.MEMBERPROPERTY(DS_1, "Version", "public.2024FC", "Description")
used to return "2024FC" but now results in a #VALUE! error in excel

Has something changed? SAC update? Add-in Update?

What am I missing here - being able to pull in the Description from my Account dimensions, measures, versions, etc. was a huge time savings in some report setups I have been using for several months.

Thanks

[ralberga]

Thank you for your time and help. As FYI, I also submitted a ticket specifically for pulling in a dimension member 'Description' because this is not a custom property. Response received is below. The first option below is what stopped working with Office 365 change (upper case 'D'). I changed to lower case 'd' and works for Users. 
Regards r.a.

--------------------------------
I checked this with Development team and the case is now sorted out.
The KBA 3497065 was updated accordingly.
In summary, we have four scenarios for using Description in the formula.

Below examples work because property description is used and it is not case sensitive:
=SAP.MEMBERPROPERTY( DS_1, "Account" , 0123, "Description")
=SAP.MEMBERPROPERTY( DS_1, "Account" , 0123, "description")

Below example works because property ID is used exactly as it is:
=SAP.MEMBERPROPERTY( DS_1, "Account" , 0123, "[Account].description")

Below example does NOT work because property ID is case sensitive:
=SAP.MEMBERPROPERTY( DS_1, "Account" , 0123, "[Account].Description")

Please check if the above also applies to your case. As per the KBA, we strongly recommend using property ID to retrieve the Description property to allow multiple languages.

Regards,

[Florent]

Hello,

The behavior change you have observed is due to a change Excal add-in team has performed in order to align the property display in the table (when you choose to display a property in the table) with what was displayed in the “properties” dialog because, until this change, both of them were not aligned.

To solve your current issue with SAP.MEMBERPROPERTY, you have to update your SAP.MEMBERPROPERTY formulas by putting the property id (available in the “properties” dialog) instead of the property description.

Best regards,

Florent Migeon, product owner for SAC Excel add-in

[bldr]

Got it - "Version.Description" instead of "Description" does indeed work.

What about for Measures? There is no properties dialog - and the options I could think of to guess at don't seem to work.

Also - Can this get reflected in the documentation at some point?
The "Analyze and Plan with Formulas" pdf - dated 2024-07-15 does not reflect this behavior, nor does the online documentation.
Both of those sources provide an example, that I believe is no longer correct/valid:

[ralberga]

Where can the 'Properties' dialog pop be found? I am asking because 'Description' is a standard SAC property not something we create and this is the one that is not working. Trying to understand how to we are to find the 'property ID' of standard/default SAP dimension properties.

[ralberga]

Posted in error, my apologies.

[bldr]

@ralberga I have found the correct text to use to get properties by:

add a table in excel - then for the dimension I need, I access the "Properties" dialog, and set it to display ID and Description.
This lets me see what the SAP.MEMBERPROPERTRY formula needs in order to get me the right piece of data
Very useful to check this way as there is inconsistency in the dimensions - and I would assume that inconsistency applies to any documentation out there as well.

As an example - see this set against the  SAP_FI_FPA_IM_S4FinancialPlan Model:

So things are working pretty well, but there is definitely inconsistency across dimensions and their properties - as well as the operation today, being a fair bit different than when I posted my original question. Also as the above demonstrates behavior today is different than it was when Florent responded and I followed-up.

So it looks like several changes to the add-in - in a couple of weeks. I run a 2x monthly reporting cycle - so breaking changes like what prompted my original question shouldn't take too long for me to notice - I would think.

Tread carefully with the Add-in - is I think the lesson here.

Good luck