Skip to Content
avatar image
Former Member

BPC 10.1 NW Embedded: EPMSaveData issue

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 25, 2015 at 08:10 PM

    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

    Add comment
    10|10000 characters needed characters exceeded