on 01-06-2015 9:56 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
"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
Thanks for your answers and instant replies as always
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.