Skip to Content
0

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

Dec 15, 2016 at 09:20 AM

64

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Gregor Dieckmann
Dec 15, 2016 at 12:02 PM
0

Hi Javier,

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

Regards,

Gregor

Show 1 Share
10 |10000 characters needed characters left characters exceeded

I have the solution:

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

Thank you

Regards,

Javier

1
Priyanka Jagtap Dec 15, 2016 at 12:28 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi,

Yes, but we want to use Analysis not EPM.

Regards

Javier.

0

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

JP

0