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

[former_member530708]

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

[former_member186338]

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.

[former_member530708]

Hi Vadim,

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

[former_member186338]

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.

[former_member530708]

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.

[former_member186338]

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+

[former_member530708]

Thank you Vadim. It is clear now 🙂