Analysis for Office SAPGETDATA function with +NodeKey(NodeTypeName)

[MelCalucin]

Per the following AFO screenshot:

I'm trying to get the value of "Actual Amount GC USD" for 0GL_ACCOUNT hierarchy node HFSV11 using the SAPGetData function, but I'm having issue with the syntax for +NodeKey(NodeTypeName) parameter.

Below is what I'm using. What's wrong with the syntax?

=@SAPGetData("DS_1"|"Amount"|"0GL_ACCOUNT+NodeKey(NodeTypeName)='HFSV11'")

I'm using the documentation from https://help.sap.com/docs/SAP_ANALYSIS_OFFICE_CLOUD/b25c777a2c8c4e3da2f472cce24f289c/40a626bf6c65465...

Thanks!

Regards,

Mel Calucin

[abastic]

hello,

from my experience, single quotes are redundant.

=@SAPGetData("DS_1"|"Amount"|"0GL_ACCOUNT+NodeKey(NodeTypeName)=HFSV11")

even this should work
=@SAPGetData("DS_1"|"Amount"|"0GL_ACCOUNT+NodeKey(NodeTypeName)="&A8)

Best Regards.