Skip to Content
author's profile photo
Former Member

Read data in yellow qm status (standart solution)

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • author's profile photo
    Former Member
    Posted on Nov 09, 2010 at 10:23 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo
    Former Member
    Posted on Nov 09, 2010 at 08:06 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Nov 09, 2010 at 09:05 PM

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.

  • author's profile photo
    Former Member
    Posted on Jun 17, 2011 at 10:18 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.