Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 15, 2016 at 12:02 PM

    Hi Javier,

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

    Regards,

    Gregor

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I have the solution:

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

      Thank you

      Regards,

      Javier

  • avatar image
    Former Member
    Dec 15, 2016 at 12:28 PM

    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

    Add comment
    10|10000 characters needed characters exceeded