Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on 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 a 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

  • author's profile photo Former Member
    Former Member
    Posted on Jan 06, 2015 at 06:07 PM

    Thanks for your answers and instant replies as always

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.