how to extract a property from a dimension in Analysis for Microsoft excel BPC 10.1 embedded

[former_member322611]

Hi,

I need to extract a property from a dimension in Analysis for Microsoft excel BPC 10.1 embedded.. with formula

Example:

Dimensiom: Account

Property: INTERCO=Y/N

I need to extract Y or N for each account with a formula.

=SAPGETMEMBERPROPERTY...but this not work..

Thank all

[Former Member]

Hi Javier,

In this case we can use the EPM plug in provided in the Analysis for Office and then using the local member can be achieved to show the Property.

@Gregor - Please correct me if wrong.

JP

[former_member322611]

Hi,

Yes, but we want to use Analysis not EPM.

Regards

Javier.

[Former Member]

Ok....If got the solution...then kindly close the discussion.

JP

[gregor_dieckmann]

Hi Javier,

if you just want to display the property of the dimension use the property as display attribute in the query.

Regards,

Gregor

[former_member322611]

I have the solution:

=SAPGetMember("DS_1"; "DIMENSION="NAMEMEMBER"; "ATTRIBUTE_Key")

Thank you

Regards,

Javier