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

Closing the open request in transaction cube

Hi All,

Is there a way to close the open request in the transaction cube before it hits 50,000 records. I need to do this via a process chain.

Please suggest.

Thansk,

Harini

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 22, 2006 at 07:05 PM

    Harini,

    you can use the funciton RSAPO_CLOSE_TRANS_REQUEST to close the open request.

    This process also can be achieved from process chain.

    hope that helps.

    Hari Immadi

    http://immadi.com

    SEM BW Analyst

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 23, 2006 at 03:40 AM

    Dear Harini;

    The answer is yes, you can SAP program 'RSAPO_CLOSE_TRANS_REQUEST_ALL3' which forces all the open request on trans cubes. I am using this program in my process chain to close and then do the roll-up everyday.

    Hope this helps.

    With Regards:

    BK

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 22, 2006 at 05:51 PM

    Hi Harini,

    I think you should be able to do it with program SAP_CONVERT_NORMAL_TRANS. You can include this in your process chain. SAP_CONVERT_TO_TRANSACTIONAL will help to convert it back to transactional cube.

    Hope this helps...

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Just information

      The program stated by Bhanu

      SAP_CONVERT_NORMAL_TRANS is used for converting an Infoprovider either Normal to Transactional or vice versa.

      ABAP report SAP_CONVERT_TO_TRANSACTIONAL allows you to convert a non-transactional infocube to a transactional infocube.

      The Function Module RSAPO_CLOSE_TRANS_REQUEST as stated above is used for closing a write request on a transactional Infoprovider. For more details refer to Note 333260 and for the prerequisites for using the above FM refer to Note 406625.

      Hope it helps.

  • author's profile photo Former Member
    Former Member
    Posted on Mar 22, 2006 at 07:19 PM

    Thank You Bhanu and Immadi, I'll try it.

    Harini

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 23, 2006 at 03:11 PM

    Hi Bk,

    Can you please specify how you use it. Do I have to pass any parameters to the program or just include that program after the load event in the process chain. Please guide me to use it.

    Thanks,

    Harini

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 24, 2006 at 09:31 PM

    Thanks Immadia nd Anurag using RSAPO_CLOSE_TRANS_REQUEST in a process chain solved this issue.

    Thank You very much.

    Harini

    Add a comment
    10|10000 characters needed characters exceeded

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.