Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 06, 2015 at 10:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • "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

  • avatar image
    Former Member
    Jan 06, 2015 at 06:07 PM

    Thanks for your answers and instant replies as always

    Add comment
    10|10000 characters needed characters exceeded