Hi everyone,
while reading some articles in the SAP help and in the SCN, I think I got a good overview of the functions EPMOlapMemeberO, EPMContextMember and EPMSelectMember. I also created some test cases to see how these function really behave.
However, I'm still not sure for what case which function suits best and I also have additional unanswered questions.
Maybe some of you can help me with that.
EPMOlapMemberO
Does changing the selection in this function only affect the context of the active worksheet or the selection of this dimension in the whole workbook?
What dependencies need to be considered using this function in combination with EPMContextMember and/or EPMSelectMember?
What are other advantages or disadvantages of this function?
EPMContextMember
What are other advantages or disadvantages of this function?
EPMSelectMember
In my test cases the function EPMSelectMember apparently did not change the value of the selected dimension in the context and it did also not change the selection of the data.
Do I need to consider any dependencies for this function?
I also tried to set the member parameter through a cell reference. While the member ID changed, apparently there was no impact on the context or on the selected data after the refresh.
What is this function suppose to do?
Is there a restriction if this function is used in combination with EPMContextMember and/or EPMOlapMemberO?
What are other advantages or disadvantages of this function?
Did I miss any other important information about these three functions?
Thanks in advance for your contribution.