BPC NW 7.5 Column MemberSet

[Former Member]

I am trying to change my Col MemberSet (e.g. the MemberSet parameter in the EVDRE control panel for the Column) to be a formula:

e.g. =I7&"|"&I8&"|"

But i keep getting an error on my EVDRE saying it's an "invalid member or flag". Whereas on the Microsoft BPC version, I can enter in the formula just fine and it will resolve.

any ideas on how to get a formula to resolve in the memberset box?

Thanks!

[Former Member]

Thanks Raman, however, that doesn't solve my issue....

Even when i put in simply =I7 in the MemberSet field, the EVDRE() throws an error saying that's invalid ....

#ERR:Invalid member or flag in <member set>, item: =I7

It

[Former Member]

Tuesday, try =EVRNG($I$7) instead of just =I7

Let me know if this works.

Greg

[Former Member]

Greg,

Nope, that didn't work either - gives the same error. It's almost as if it doesn't recognize that it's a formula.

[Former Member]

This is working for me in the memberset:

=C5&"|"&D5

Where C5 is Actual and D5 is Budget

Please make sure that you have expanded your Columnset or Rowset accordingly to accomodate the pipe character. You need to have separate ranges defined separated by a comma. For example, my memberset is in the ROWS so I added the following in the Rowkey range:

EVRNG(E5:E6,E8:E9)

Greg

[Former Member]

Greg -

That's what i started with originally... and it still throws the same error. Even if i simply "hard-code" the value, e.g. make it equal to: =2005.JAN&"|" or ="2005.JAN"&"|" it returns the same error. It's almost like it doesn't accept "Excel" formulas....

I have this same feature working in the Microsoft vsn using the same formulas, etc

Edited by: Tuesday Howell on Oct 25, 2010 8:19 PM

[Former Member]

Does hard-coding the entire memberset work?

2005.JAN|2005.FEB

If this works fine when you hard code this, and the formula works fine as you say in the Microsoft version but not in the Netweaver version, I think you should submit this as a bug to SAP through the SAP helpdesk.

Enter EPM-BPC-NW as the application area and use the word BUG in the subject line.

Greg

[Former Member]

Yes, hardcoding it that way works.

How do I submit to SAP helpdesk?

[Former Member]

Go to Service.SAP.com and login using your SAP login. Click on the link for the SAP Support Portal then click on "Report a Product Error" (top of the page).

Greg

[radharamansingh_rajkumar]

Hi,

You can use this way in your memberset.

e.g. =I7&" OR "&I8&" OR "

Hope it helps

Regards

Raman