Skip to Content
0

SAPBPC10MS How Remove members if a specified local members is empty.

Jan 12, 2017 at 11:52 AM

51

avatar image
Former Member

Dear All,

I m working on a dynamic report for my client and I m blocked about one specification that it asked :

Accordind to the value of a localmember (local member in column), if the cell is empty, the dimension member need to be suppress of the Row Axis. So I have to use VBA for that.

I already identify my loop and my condition. But I don"t how I explain to the system how suppress the member from the row axis.

For example :

Count = 10

For Each Cell In Sheets("Sample").Range("A10:A25")
If Cell.Value = Null Then

??????

Else

Count = Count + 1

End If

Is anybody have an idea ??

Thanks in advance

Kind Regards

Jonas

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

2 Answers

Vadim Kalinin Jan 12, 2017 at 07:17 PM
0

You can hide the row using VBA - no other options.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 16, 2017 at 03:52 PM
0

Thanks for your reply.

Yes, Macro seems to be right.

Unfortunately, I can't only hide. I have a Sum(EPMAllMembers) too.

What about the BPC RemoveMemberFromRowAxis action ?

I'm not sure it works ( or I don't know how it works.)

Furthermore, If you have an idea for filter on only one dimension member of three dimension row axis. It could be also good for me.

To be more clear I try to have a filter only on columns with Real figures. ( not budget or forecast).

Many thanks

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

Sorry, but in order to get some answer you have to prepare very clear explanation with very detailed samples and screenshots!

RemoveMemberFromRowAxis works fine if you have this member directly (not as a children of some parent)!

"If you have an idea for filter on only one dimension member" - absolutely not clear!

"To be more clear I try to have a filter only on columns with Real figures" - also not clear!

0