cancel
Showing results for 
Search instead for 
Did you mean: 

data send

Former Member
0 Kudos

Hi Experts,

I am in process of preparing a customized template which sends data to bpc cube. In earlier version 7.5 we used to have the below MNU functions to get this implemented by using a macro button and assigning the below functions to the macro button.

Can we use the same API's in BPC 10 by implementing the code by clicking on a button. Have read thru the help but could not see the results.

Help me with sample code if any .

   Application.Run "MNU_ETOOLS_EXPANDANDREFRESH"

   Application.Run "MNU_ESUBMIT_REFRESH"

Below code only refreshes the data but not sends to the server with number of records and comments.

Dim EPM As New FPMXLClient.EPMAddInAutomation

Sub SAVE_DATA()

EPM.SaveAndRefreshWorksheetData

End Sub

Thanks,

SSK

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

Hi,

The "Below code only refreshes the data but not sends to the server with number of records and comments." - works fine! You are doing something wrong else...


Vadim

Former Member
0 Kudos

Hi Vadim,

Could you please let me know which EPM function sends data to the server and also RETRIEVE or SEND buttons on excel .Thanks.

Can we use the same API's in BPC 10 by implementing the code by clicking on a button. Have read thru the help but could not see the results.

Help me with sample code if any .

   Application.Run "MNU_ETOOLS_EXPANDANDREFRESH"

   Application.Run "MNU_ESUBMIT_REFRESH"

SSK

former_member186338
Active Contributor
0 Kudos

The functions are clearly explained in EPM help:

SaveWorkbookData - performs a save on the workbook data

SaveAndRefreshWorkbookData - performs a save and a refresh on the workbook data.

SaveWorksheetData - performs a save on the worksheet data

SaveAndRefreshWorksheetData - performs a save and a refresh on the worksheet data

All mentioned functions are working fine in many projects!

Vadim

Former Member
0 Kudos

Hi Vadim,

Thanks for your answer.I have already gone through the EPMofc_10 user help guide but i dont see anywhere it says the above API's updates/sends data to the server..

I wanted to understand if we can still use the below functions in BPC 10 or the replaced EPM functions for them.

   Application.Run "MNU_ETOOLS_EXPANDANDREFRESH"  -- used to only refresh

   Application.Run "MNU_ESUBMIT_REFRESH" --- submits/sends the data to BPC server

Rgds,

SSK






former_member186338
Active Contributor
0 Kudos

"I wanted to understand if we can still use the below functions in BPC 10" - No, we can't!

To refresh only - you have:

RefreshActiveWorkBook

RefreshActiveSheet

RefreshActiveReport

RefreshReportDataOnly

Refresh

MNU_ESUBMIT_REFRESH:


SaveAndRefreshWorksheetData

SaveAndRefreshWorkbookData


Vadim


P.S. There is no EXPAND in BPC 10 EPM report! "Expand" happens automatically

Answers (1)

Answers (1)

Former Member
0 Kudos

Thanks for your answers and instant replies as always