How to triger EPMSaveData function in BPC 10

[Former Member]

I need to use  EPMSaveData function to save the data to server,  I have the value for all the parameters, but I am not sure how could I triger the execution of this EPM function. for the other epm fucntion, such as EPMMemberProperty it will run by itself.

Thanks,

[nagar]

how change in manual templates to show actual data in BPC

[former_member186338]

Sorry, but your "answer" is not related to the very old question. Ask a new question and describe details.

[Former Member]

Hi ALL,

How can I disable " Refresh" & "Save Data" in EPM tab Excel ribbon pane using vba code. I try below but entire ribbon hide. Any thoughts?

Sub Workbook_Open()

    Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"

End Sub

[former_member186338]

Hi,

Please look on my answer here:

The button will not be disabled, but pressing on the button will not save data (message will be shown). The same can be done for Refresh.

Vadim

[Former Member]

Hi,

This function is executed only when you click on the save button in the ribbon.

However, if you have created an input form using the report editor, then you need not use this function. All the data cells will already be input enabled, and that data will be saved even without the EPM function.

This function comes in handy, when you are trying to save some ad hoc value, which is not a part of the input form.

Hope this helps.

[Former Member]

The requirement is to not use the save button in the ribbon, but only a custom button,  I am not which standard macro will call this, is one of the existing NMU function such as

MNU_ESUBMIT_SENDDATA working, or we have create a customized one?

[Former Member]

Hi Jian,

You can create a button that trigger a Vba code running the EPMSaveData.

But this process will send all data from the worksheet or workbook (depends on code).

Option Explicit
Dim client As New EPMAddInAutomation
Sub Save_Click()
   client.SaveAndRefreshWorkbookData         'Will send all data from all worksheet
    'client.SaveAndRefreshWorksheetData       'Will send all data from actual worksheet
End Sub

Regards,

Lucas

[Former Member]

Lucas,

   Thanks for the response, how about if  I am going to use the EPMSaveDataOnly function instead of EPMSaveData function? where I can change the EPM function in your code?

[Former Member]

Hi Jian,

It's the same process as EPMSaveData.

The main difference between two functions is that EPMSaveData retrieve the data form server too besides to save, and EPMSaveDataOnly just save to server.

The process of recording the data is triggered by Save process.

Regards,

Lucas

[Former Member]

Hi Jian,

As Lucas said, I think you wont have to change anything in that code now that the SaveAndRefresh will send the values contained in both functions EMPSaveData and EpmSaveDataOnly. I have only used EpmSaveData but i think the difference between those two is that the fist one will retrieve the current value in the intersection you are going to write and show it on the cell that contains the Epm function. The second function will just save the data without retrieving the current value, in early versions EVSND and EVSEN has the same behavior.

Regards, hope it helps.

Pedro

[Former Member]

Hi Jian,

You can definitely create a button, and assign a macro to that button. Please note that this macro is same as the standard send button in the ribbon. If a cell has the EPMsavedata function then it will be saved.

Having said this, please note that if you make a template using the report editor, and make it as input form, then this macro will send all the data.

Hope this helps.

[Former Member]

Thanks all the the reply.

   The reason why I asking this question is because I notice that when I use the EPMSaveData function, if I point the dimension's value such as version to actual, while the context value of version is set up as budget, it will generate two record under actual and budget, which is not what I want. the save button from the ribbon will take the dimension value form context while the EPMSaveData will take value from parameters and then is context value if the parameter value is blank. this means that in order to prevent this if we need to create custom save button, we need to deactivate the save button in the ribbon.

[Former Member]

Hi Jian,

First of all, we need to understand how are you creating your template. If you have used the EPM pane or the new report feature, then you can just switch the template to input form. You dont need the EPMSaveData function.

This function is required, when you hard code some members in the template, manually (without using the report creation method as above).

Hope this helps.

[Former Member]

Hi Jian,

When you execute a process of saving data, be by ribbon buttom or by function, the system will save all data modified or inputed in the report. You can't choose what will be sent to server.

Unless you set the report as non input form in the report option (I think, have to test) for the values you don't want to sent and use the EPMSaveData to the values you want to sent. Anyway, if you don't want to sent certain data, just protect the cells for non user actions.

I don't know if understand your requirement correctly.

Regards,

Lucas

[Former Member]

Thanks for all the input.

   In BPC 7.5, we have a lot of standard  MNU menu commend, for example: MNU_ESUBMIT_SENDDATA, could we still use the standard MNU in BPC 10? is hte answer is yes, could I use MNU_ESUBMIT_SENDDATA to save the data and replace the EPMSaveData function?

[Former Member]

Hi,

MNU functions are not supported in BPC.

First of all, let me understand what is the exact requirement. Do you just want to have button to send data? If yes, then you can use the API - "SaveWorksheetData".

Hope this helps.