Skip to Content
0

Offline Submission in SAP BPC 11 Embedded/BPC Optimized

Jan 11 at 11:20 AM

125

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Leila Lappin
Jan 11 at 05:31 PM
0

Hi

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

Best Regards,

Leila Lappin

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Leila Lappin,

No worries

Regards,

Karthik

0
Pratyush Panda Jan 11 at 04:42 PM
0

Hi,

Try this document and see if it works for your case

Simple Offline Planning

Prat

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Prat,

Thank you for the document, but primarily we are looking for some solution without using any macros code.

Regards,

Karthik

0

Looks like it's the only solution!

0
Selva AM Jan 11 at 07:33 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0