EPM function for getting data of children level BPC 11

[former_member1197491]

Hello,

I am searching for an EPM function to load automatically the children level's data of a member by Refresh. For example, when I choose entity Asia in Column axis and click Refresh. The children level (Singapore, Vietnam,...) will also apprear in the columns with their data.

At the moment, I choose Asian in a cell ( Cell E1 is Asia) and click Refresh. I can get only data of ASIA.

=@ EPMOlapMemberO(E1;"[PROFIT_CENTER_B].[PARENTH1].[ZASI0861]";"ZASI0861 - ASIA";"";"000")

Do you have any solution to get also data of children level of Asia?

[OwenLiu]

Welcome and thanks for visiting SAP Community to get answers to your questions. Check out our tutorial to get started in SAP Community: https://developers.sap.com/tutorials/community-start.html By adding a picture to your profile you encourage readers to respond to your question. Learn more about your profile here: https://developers.sap.com/tutorials/community-profile.html

[former_member186338 · Accepted solution]

Use EPMDimensionOverride

https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.38/en-US/f9bc06b66faf1014878bae8cb...

=EPMDimensionOverride("000";"PROFIT_CENTER_B";E1&",DEP("&E1&")")

[former_member1197491 · Accepted solution]

Hello Vadim,

I would like to thank you so much for your help. It did work so well. However, I have this message every time I change an entity. The formula in column of Asia will also disappear. It is obliged to paste the formula every time I change an entity. Do you have any idea for solving this problem? Thanks in advance.

[former_member186338 · Accepted solution]

nguyen1994

Sorry, but the formula have to be completely outside the report!

Please accept the correct answer.