BPC 10.1 NW Embedded: EPMSaveData issue

[Former Member]

Hi all,

we are working on SAP BPC 10.1 NW Embedded and EPM AddIn 10 SP 21.

we have a BEX Query with TIME and KEYFIGURE in column and VENDOR in row, built on the aggregation level.

In the input form, we need to put an EPMSaveData formula in a local member.

The formula we wrote is:

=EPMSaveData("2",EPMModelCubeID(),VERSION,(EPMDIM_CURRENT_MEMBER(TIME)),(EPMDIM_CURRENT_MEMBER(VENDOR)),"MyKeyFigure")

where "2" is the value we want to save on the specified region on MyKeyFigure and VERSION is an Excel range named by us.

we have included MyKeyFIgure in the query and set it as input ready, but we always get errors.

Please note that the Key Figure we have in column is different from the one we want to input data on.

Can you please help me undestand what we are doing wrong?

Thank you in advance,

Daniele

[francielle_chaves]

Hi Daniele,

In the following link you can donwload the EPM Add-in user guide that explains each parameter used in EPMSaveData function:

http://help.sap.com/businessobject/product_guides/boeo10/en/EPMofc_10_user_en.pdf

If after review this document you continue seeing the same errors, please provide more information about these errors.

Also, here are some important points when using EPMSaveData function:

• If the description of a member exists in several dimensions, once you have entered the function, a message appears, stating that the description is ambiguous and recommending that you use the ID of the member instead.
• If the ID of a member exists in several dimensions, once you have entered the function, a message appears, stating that the ID is ambiguous and recommending that you use the full unique name of the member instead.
• Please note that the EPMSaveData function does not support free text key figures.

Best regards,

Francielle