cancel
Showing results for 
Search instead for 
Did you mean: 

EPM function for getting data of children level BPC 11

0 Kudos

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
Product and Topic Expert
Product and Topic Expert
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

Use EPMDimensionOverride

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

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

0 Kudos

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
Active Contributor

nguyen1994

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

Please accept the correct answer.

Answers (0)