Closing the open request in transaction cube

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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

Thank You very much.

Harini

[Former Member]

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

[Former Member]

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

[Former Member]

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

Harini

[former_member188975]

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...

[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.