cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

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!

former_member186338
Active Contributor
0 Kudos

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