VBA Upon Changing a Member

[Former Member]

Hello,

I am trying to have some code run after any type of refresh happens, and I can't get it to activate the code when I change a member in the axis.

Just for simplicity:

This activates if you push the Refresh button.

(in module)

Sub AFTER_REFRESH()

Rows("12:12").RowHeight = 9

End Sub

This activates if you change the context member.

(in module)

Sub AFTER_CONTEXTCHANGE()

Rows("12:12").RowHeight = 9

End Sub

This activates if you use member recognition and type over the cell (so the cell physically changes)

(in the Sheet)

Private Sub Worksheet_Change(ByVal target As Range)

If Not Intersect(target, Range("$A$4")) Is Nothing Then

Rows("12:12").RowHeight = 9

End If

End Sub

However, if you just double click in to a member of the page axis and select a new member with the member selector box, it doesn't activate. I tried looking into the EPM Documentation, but couldn't find a solution to this, and everything I tried has failed.

Any ideas on how I might accomplish this?

Thanks,

Alex

(I am using BPC 10.0 NW, EPM SP20)

[former_member186338 · Accepted solution]

Hi Alexander,

Unfortunately it will not - read here:

Vadim

[Former Member · Accepted solution]

Hello Vadim,

That is interesting that it is not available. Personally, I would think AFTER_REFRESH "should" be triggered each time the data changes (aka, I shouldn't need my second or third example above. Each time the data changes, it should activate this trigger.) It is odd that SAP would have this trigger physically only triggered upon clicking the Refresh button and not EVERY time data refreshes....that basically makes it useless.

Regards,

Alex

[former_member186338 · Accepted solution]

Unfortunately no way

Vadim