Skip to Content
0

SAP BPC 10 - Allow Update of Work Status for Multiple COB and Period

Nov 28, 2017 at 10:27 AM

84

avatar image
Former Member

Hi All,

Our Business users expects to have a option to select 'Multiple COB and periods' for the work status locking. As per the current standard screen, multiple selection(Checkbox) is not available.

Is the workaround to create a DataManager->Custom_Logic badi -> Code with class CL_UJW_WORK_STATUS_MGR ? or Any other alternate solution available?

Kindly help.

We are using SAP BPC 10, below are the components details

SAP_BW 730 SP14

CPMBPC 800 SP19

EPM Addin 10 SP 25 Patch 1 .Net3.5 Build 9489

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

1 Answer

Vadim Kalinin Nov 28, 2017 at 10:32 AM
0

You have to implement very simple code for custom logic badi:

https://blogs.sap.com/2013/10/28/how-to-change-work-status-from-script-logic-using-badi/

In the script logic loop badi call with the required members.

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

Hi Vadim,

Thank you. Will implement the Badi and close the thread.

0

With BPC 7.5 it was possible to use Excel VBA to do the job:

https://blogs.sap.com/2014/01/17/bpc-nw-75-work-status-setting-from-excel-vba/

Not possible with EPM.

0
Former Member
Vadim Kalinin

Hi Vadim,

Sorry i am confused with your latest reply ( Not possible with EPM )

You mean through Excel VBA it is not possible to achieve in BPC 10(EPM) ?

Is it possible to achieve following the below blog for BPC 10 ?

https://blogs.sap.com/2013/10/28/how-to-change-work-status-from-script-logic-using-badi/

Thank you.

0

It's ABSOLUTELY clear from my blog and my comment that VBA approach (to create special URL) will work ONLY for BPC 7.5! Not for BPC 10+

0
Former Member
Vadim Kalinin

Thank you Vadim. It is clear now :)

0