Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Row/Column member selector run from VBA

Hello Gurus,

Is there easy way to open Row/Column axis member selector using VBA?

I need to create custom button in a report which will allow user to select members in TIME dimension which in my report is in column axis.

I already tried solutions involving recording macro or using EPMDimensionOverride.

Each solution either failed or didn't meet requirements so I guess the easiest way would be to write VBA code which will behave exactly as if user clicked on dimension in time axis as presented on below screenshot.

Any help on how to do this or what functions/macros to use will be highly appreciated.

Many thanks!

Maciej

replied

Hi Maciej,

You have to use the code like:

Dim epm As New FPMXLClient.EPMAddInAutomation

Public Sub SelMem()

Dim strTimeMembers As String

Dim strConnName As String

strConnName = "INFILE - SIM"

strTimeMembers = epm.OpenMemberSelector(strConnName, "PERIODS", "")

MsgBox strTimeMembers

End Sub

The Member Selector dialog will be:

In strTimeMembers you will receive the list of selected members:

You can parse this string to array of members and use it later for EPMDimensionOverride formula or VBA code...

Vadim

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question