How to incorporate work_status locking in default logic

[Former Member]

Can we use script logic to lock data using work_status? Basically I want system to check the work_status as soon as the default logic runs?

[Former Member]

Hi,

I dont think that can be done through logic.

Even if you had this facility, would you like to go for it? The default logic runs for every DM package, input schedules, etc. So, whenever you do any kind of manipulation, the work status would have been locked.

Nevertheless, this facility is not available. This cannot be done through logic. You can keep it in your custom menus, BPFs, Reports, Input Schedules or you can do it directly through BPC Web.

Hope this helps.

[Former Member]

I am not sure about Microsoft platform but in SAP BPC NW, it's possible to do through BADI which is connected with Script Logic. Perhaps, in Microsoft version it's possible to run special code from Script Logic which changes WorkStatus table.

in SAP BPC NW, We have written own workflow which manages forms/reports and even send them to different users. Our Workflow framework changes workstatuses from BADI. Also, it sends emails.

[Former Member]

Hi Pavel

You can call a stored procedure from script logic, with the following command

*RUN_STORED_PROCEDURE={stored procedure name}([])

In the stored prodcuere you can check the WorkStatusMemInfo table, and then in your code you could send mails, use the below link as an example to send mail from a sp

[Sending E-Mail through SQL Server stored procedures|http://www.dotnetspider.com/resources/19638-Sending-email-through-sql-server-stored-procedure.aspx]

Kind Regards

Daniel