Skip to Content

Offline Submission in SAP BPC 11 Embedded/BPC Optimized

User Requirement is to do planning when he is not connected to SAP system. User saves his work in an excel file on his local system and need to submit his work when connected to network.But every time he connect's to network, Analysis for Office will refresh it from server and the draft of planned data is getting changed to previous values and if he don't refresh, the save button is not enabling.

How to implement this offline submission in BPC Optimized ? without using any Macros Code

i have searched through forums but couldn't find a proper Solution.

Regards,

Karthik

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 11 at 05:31 PM

    Hi

    I gave you the answer for EPM Add-in, sorry. I didn't realize you were using AO

    Best Regards,

    Leila Lappin

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11 at 04:42 PM

    Hi,

    Try this document and see if it works for your case

    Simple Offline Planning

    Prat

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11 at 07:33 PM

    Hi Karthik,

    In AO, in the components tab, you can select the query and set out the Refresh on Open check box. This way your workbook will not refresh once you open it.

    --Selva.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Selva,

      we have unchecked Refresh option, but to save the draft of planned values, the SAVE option is disabled until we click refresh and once you refresh the offline work which we have done is getting changed to previous values.

      Regards,

      Karthik