Skip to Content
author's profile photo Former Member
Former Member

Report on process chains using SEM-BPS

We are looking to develop a tool to:

1. Monitor data loads at the process chain level

2. Within in the same tool, enter error resolution /

action steps for all failed loads

3. Report out % of successful or failed loads, using the data captured by the tool.

We have studied the BW Tables rspcchain, rspcchainattr, rspclogchain, rspcprocesslog, rspclogs, rseventchain and

rspcchaint.

We are considering the following options:

1. Develop an ABAP report and allowing the process chain monitor to manually enter the error resolutions (Perhaps in a Z-Table)

2. Create an InfoCube in BW using the above tables and then write a query, but we can not allow the user to enter error resolutions in the query.

3. Create a transactional infocube in SEM-BPS using the above tables and use the input functionality of tansactional infocube to facilitate the error resolution report entry.

Can anyone suggest any alternate solution, or has anyone encountered similar requirement on project?

One more doubt to check: is there any way to create an infoobject with CHAR type to enter data with 1000 or more characters? Or is there any other alternative solution to it? The doubt is to take care of the text entry for the error resolution.

Milind Vad

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2004 at 12:28 PM

    Just some thoughts:

    Have you considered using document service in BW or even KM (Portal) technology rather than CHAR 1000+ fields? This would give you more flexibility also on the type of document.

    For loading there are monitors available (based on tables like RSMONMESS). If you are interested in loads only (and not other process types), maybe using information from the BW load monitor could be beneficial (like RSMONMESS) rather than the process chain stuff.

    Maybe it's even worth having an InfoObjekt with a resolution code that links to a document describing the resolution with a key and whenever there is a new solution available create a new key with a new document. That would be most beneficial for reporting (like how many times has this problem / resolution occurred and the like).

    Regards, Klaus

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      There are SEM-BPS APIs, especially API_SEMBPS_SETDATA and API_SEMBPS_POST that allows you to write data directly into a transactional InfoCube. Then you don't need to do any data staging to run the reports, no jobs that run any five minutes or so and you have state-of-the-art reporting without any additional effort.

      Best regards

      Dirk

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.