To get report on workflow history

[Former Member]

Hi Experts!

I have a requirement to extract a report from MDM which tells about various approver details and step details.

I understand I can get this through Data Manager workflow history but that wont serve the purpose here.

Please guide me how can i get a report from SAP MDM for workflow history,also what should be done after a workflow ha been completed as the completed workflows also keep on piling in the Data Manager and will add to memory usage.

Thanks in advance!

Regards,

Ravi

[Former Member · Accepted solution]

Hello Ravi

MDM 7.1 supported workflow logs.

In mds.ini in [MDM Server\Databases\RepositoryInfo] section you should insert:

Workflow Detailed Report=True

Mds create special report where it is loging all workflow events.

You can see it throught MDM Console.

Regards

Kanstantsin Chernichenka

[Former Member · Accepted solution]

Thanks Sailesh and Kanstantsin for your prompt response.

we are currently at SAP MDM 7.1 SP04 and we want workflow histry steps for SOX compliance.

Logs in console are not relevant here.

What is the way to achieve this through Java API,please guide me on this.

Thanks,

Ravi

[Former Member · Accepted solution]

Hello Ravi,

[SAP Note 1265626|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1265626] may be helpful for you.

[Former Member · Accepted solution]

HI Shailesh!

Thanks for your valuable input.

But Still I am not sure how do I extract workflow history using Java API's with SAP MDM 7.1.

I undertsand these get stored in a datavase table,which classes can I use to extract the same?

Thanks,

Ravi

[Former Member · Accepted solution]

Hello Ravi,

For getting workflow history through Java API...

Try executing Java API commands in below sequence.

1. RetrieveWorkflowTasksCommand (passing TableId)

2. RetrieveWorkflowTaskActionsCommand (passing WorkflowTask obtained from step 1)

3. ExecuteWorkflowTaskActionCommand (on WorkflowTaskAction.SHOW_HISTORY task got from step 2)

4. Call getHistoryMessage() on ExecuteWorkflowTaskActionCommand object (created in step 3).

[Former Member · Accepted solution]

Thanks Shailesh!

Please tell me what will be the outcome of this code.

Can I publish the same?

also on passing TableId all the available jobs in Workflow will be captured,please confirm my understanding.

Regards,

Ravi

[Former Member · Accepted solution]

Hello Ravi,

getHistoryMessage() method will return a String which is exact copy of what you get in DataManager show history action.

Since its a String, you can do whatever you want in Java.

[Former Member]

Thanks Shailesh!

[Former Member]

Hello Ravi,

Please guide me how can i get a report from SAP MDM for workflow history

Other than Data Manager, you can use Java API for getting workflow history.

what should be done after a workflow has been completed

Ideally completed workflow should be Archived or Deleted permanently.

Just released SP6 of MDM 7.1 has Workflow Archiving support (in Data Manager & in MDM CLIX).

If you are not using MDM 7.1 SP6, then again Java API can help you.

What's new in SAP NetWeaver MDM 7.1 SP06 can be found here [http://help.sap.com/saphelp_nwmdm71/helpdata/en/be/e0048b426b4c20957078b61ec71e46/frameset.htm]