VBA to RemoveMemberFromRowAxis based on property

[former_member507106]

I would like to remove the rowmembers based on property values.

Below is my vba code :

Sub Button5_Click()

Dim epm As New FPMXLClient.EPMAddInAutomation

Dim sh As Worksheet

Set sh = Sheets("Sheet1")

epm.RemoveMemberFromRowAxis sh, "000", "ACCOUNT:ID=DOM", 12

epm.RefreshActiveReport

ACCOUNT is my dimension

ID is the property

DOM is the property value.

But still not working.

No error as well.

Appreciate help.

Best Regards,

Guru Rajan.V

[former_member507106]

Dear Vadim,

Instead of excluding the members in the report ( manually in multiple reports ) i would like to build a logic based on selection and VBA should be able to exclude those members from the report. By selecting parent node all the members will be displayed, but i would like to filter.

Best Regards,

Guru Rajan.V

[former_member186338]

I Don't think that VBA is a good idea for this requirement. You can add filter by property in the member selection form without any VBA. Is it clear?

[former_member507106]

Dear Vadim,

Thank you for your reply.

Actually i selected all the members in my Report. I can see the member in my report. Now i want to remove based on condition. i am not sure of the format based on condition. Help document refers to the following dynamic values.

List of supported dynamic relations values:

Member = 1

Children = 2

Member and Children = 3

Descendants = 4●

Member and Descendants = 5

Leaves = 6

Same Level = 7

Siblings = 8

Ascendants = 9

Member and Ascendants = 10

Member and Leaves = 11

Property = 12

Named Set = 13

Member OffSet = 14

Member Property = 15

Best Regards,

Guru Rajan.V

[former_member186338]

I don't think that the property =12 can be used to remove by property. Please explain what do you want to achieve in general?

[former_member186338]

Sorry,

But the third parameter of the function is member Id and not the filter condition. Please read help.

If you want to remove members using some property you have to first read all members, then read property of each member, then create the list of members to remove and then - remove.

Vadim