How to calculate aggregated amount across a property with member formula?

[alexandresamuel]

Hi experts,

I need help for following case in SAP BPC NW 10.1.

In my Entity dimension, I have a RS property.

I have the following entities:

E01 = RS property = <empty>

E02 = RS property = Y

E03 = RS property = Y

I can't create a new hierarchy which organized my Entity dimension by RS property.

So I want to use a member formula which agregate all my Entities which have RS property = Y

So I create a member RS_Member in my Entity dimension.

In Member formula functionality, I create this script:

[ENTITY].CURRENTMEMBER.PROPERTIES("RS")="Y"

When I create a new report, I have following datas:

E01 = 10

E02 = 20

E03 = 30

RS_Member = 0

I expect 50 amount on my RS_Member.

Is there an incorrect syntax in my member formula?

Thanks for help.

Alexandre

[former_member186338 · Accepted solution]

You can't aggregate by property. Use hierarchy, may be new hierarchy.

[alexandresamuel]

Bad news,

Thanks for answer.

[former_member186338]

Please accept the correct answer and close the question.