Question:
Hello All
I tried to use
RSAPO_CLOSE_TRANS_REQUEST to close the request in se37
by providing the cube name as the input
still i see the load is running in the cube
Any help
Thanks
GA
Answer:
Hi,
Why do you want to close the request? Is that a requirement. For reporting there are ways to get the BPS data without closing the request.
Anyway if you want to close the request go to the Infocube administration and set the overall status to OK (green). This step will close you request.
I hope it helps,
Nelson
Answer:
Hi Nelson
I tried that, the reason to close is to test the data load.
ion the monitor i see this 'Request still running"
i don't see the data in the cube but the ODS has the 2 records which is not updated in the cube.
I see cube mange showing 2 recordes transfered
But not added
any idea
Thanks
cheers
Arun
Answer:
If you are loading data from R/3 the system should close the request automatically. If the request does not close automatically you may have a problem.
If planning in BPS you can close the request as I told you, by changing the status.
Nelson
Answer:
Hi
Does any one know
How to set the sem packet size from 50k to 100k.
thanks
akawshik
Answer:
Closing a request automatic is very useful if data from SEM (transactional infocube) should update another or perhaps be manipulated in another program. Writing ABAP on an ODS that should not be triggered by a user is faster that using SEM-BPS. Furthermore you have a possibility to delete a certain request if you now something need to be heavily recalculated.
Answer:
You can try changing Max Lines in ROIDOCPRMS and I guess this should work since interfacing is similar for Data Mart or Transactional. However, it is a scary thing since it will alter so many things in performance tuning and memory management, etc. And those internal tables during BPS executions, well I am not sure if you would take all those in perspective for your implementation.
Maybe you can educate me as to why that is so important to increase it? and how we can handle other performance issues?
Regards
Dheeraj