on 11-09-2010 8:29 AM
Good day, everybody.
I have two cubes. And I have a transformation rule between them - from real-time cube into trans.cube.
And the problem that I can't get data which are in yellow QM status in real-time cube. So after the end of transformation rules, there are no data in target cube which status is not green in source cube. But I need all data to be read.
Any ideas?
i tried to change data integrity for source cube, but it didn't help.
Hi Marat, to make yellow requests visible in reports please make sure that 'Data integrity' is set to 1 in Infocube/multiprovider properties (open cube and in the menu: Invironment->Infoprovider Properties->Change) . Also in the query properties (in RSRT) make sure that Req.Status is set to 1 also.
I had the same problem but after these settings applied reports showed KFs from yellow requests of planning cubes.
hope it helps . thanks.
BR
Mikhail
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mihail
I have a real time planing cube from which i have been loading data to another cube using a process chain for every 15 min in production.
But when ever i save the data in the planing mode it is updating only after the second referesh i.e after 30 min .
Iam calling the below programme to close the yellow request to green, which is happening but picking the delta request only after 30m only..
CALL FUNCTION 'RSAPO_CLOSE_TRANS_REQUEST'
EXPORTING
I_INFOCUBE = 'Z8_IOD_CC'
* EXCEPTIONS
* ILLEGAL_INPUT = 1
* REQUEST_NOT_CLOSED = 2
* OTHERS = 3
.
IF SY-SUBRC <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
* WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
Hi Marat Iskhakov
If you use a Process Chain, you can add the process "Switch Realtime InfoCube to Load Mode" before to DTP in this process chain.
This force to change the Qm Status to green.
Regards !!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks to everybody.
Of course I know that we can just switch cube between two modes and get green status of request. We can do it manualy of usin proccess chain.
But if I do it when user is planning.... This is the problem. I don't have an opportunity to change the mode of cube, that's why I try to get data in yellow status.
But as I see there are no real standart solutions to do it. of course I can just use routine in transfer rules but I hoped there is any standart way.
I wrote OSS in SAP, may be it will help.
I need a BW solution for exact problem:
- i can't change status to green, because users are planning at this time.
- i can't use IP or BPS because there are complicated rules in transformation and it's very bad style to use FOX for hard coding.
I'll write here about results.
And thanks for your help.
Any particular reason why you don't just load the target cube the normal way (non-real time)? Either way you'd be pulling the data as of a certain point in time.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Is there any reason for your source cube QM status to be in yellow status, Yellow status indicates that the load is in process and it will not be considered while further processing.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Is the cube used for planning?Once planning is done and when you want to load the data from planning cube to another infocube change the real time behaviour of the cube to planning not allowed. This will make the yellow request green. This can be done manually by right clicking on cube and choosing realtime properties or using process chain. Once data load is finished then revert the status of cube for planning. If in query you need data from yellow request, then go to to the required query in RSRT and click properties. In data integrity choose option 9. This will make ur query read all the request in cube even open request(yellow request). Hope this solves ur problem.
Regards,
Raghavendra.
Edited by: Raghavendra Padmanaban on Nov 9, 2010 3:16 PM
User | Count |
---|---|
74 | |
26 | |
11 | |
10 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.