Skip to Content

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

EPMFunction to get member ID based on properties

Hi experts,

I'm looking for an (EPM)function to receive a certain dimension member into an excel cell based on serveral properties.

Tried EPMDimensionPropertyValues() and EPMSelectMember() but the Point is that in any case a need to know the ID of the member. But in my case i only know properties which exactly describe this member.

Resolved the case at the Moment with EPMDimensionOverride, but this in my opinion only works for row axis and column axis. But when using the page axis i need to give the member ID directly to the OLAP function. But (as i described) i don't know the ID.... just the properties...

Thx in advance



Former Member

Yes, exactly the same! EPMContextMember has the same behavior as EPMSelectMember...

Dummy report (with may be double refresh issue) or VBA!


0 View this answer in context

Helpful Answer

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