on 2008 Jan 10 2:10 AM
Hi friends,
I have a transactional cube,
Data is written to this cube via planning and there is a open request starting with APO_* and it is in the status YELLOW (with less then 100 records).
Now i have loaded some plan data from different cube to this transactional cube by converting it to LOADING Mode.
After the Load, when i am converting the transactional cube back to PLAN mode, it is throwing an error as below,
"Request APO_R4882264JTZCSE59XAPX891A3Y(0000009905) is yellow or red in InfoCube ZUCAPX01; cannot switch to planning"
How can i close automatically the APO request before loading data.
Regards
Shashi
its working now.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Check Note 1063466 - Transactional request is not set to qualok
Rgds,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you can set the real-time infobue through environment->automatic request processing-> set quality status to OK(confirm quality of data) , check this flag.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi youmenbi,
You can use a program "RS closerequest" as ABAP program processtype to close the open request...in the process chain....I dont remeber the exact program name...just search in se38 with the above texts.
This process type would come after/before the data load process.
Hope it helps,
Ajay
Edited by: Ajay Chauhan on Jan 10, 2008 12:20 AM
Hi Youmenbi,
Just check the errors as to why that PC is failing at that step..are u giving the correct parameter to the program....
You can also use the program RSAPO_CLOSE_TRANS_REQUEST_ALL3...this will close all the open requests in all transactional cube in the system...if u are sure that there isno other transaction cube impacted than u can use this...
But i think u shud be able to do that with earliier one also...
Ajay
hi,
i created a custom report program(Z_BIIP_CLOSE_REQUEST) by calling FM RSAPO_CLOSE_TRANS_REQUEST and passing realtime infocube name and used this in the PC..
the PC gives error on the step when i am switching the realtime cube from LOAD mode to PLAN mode.
it gives the error "the APO request is in yellow; cant switch to planning."
that means still the request is not closed.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.