Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

data send

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

Former Member
replied

"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

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question