Skip to Content
avatar image
Former Member

Check infocube and verify that all request in there are reportable

hi all,

How can i verify that infocube that request are available in for reporting,,Is there any SAP or Z program/FM to find the solution.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 21, 2014 at 03:45 AM

    hi Sajoy,

    IF you go to the manage of cube, you will find an available for reporting sign in the infocube - whichever request has this is available for reporting.

    Tables:

    RSMDATASTATE SIDs are the same as the request no that you see (in request tab in 'manage'). Request IDs in the target can be checked in RSICCONT table.

    The value in RSMDATASTATE tells the max value for which QM is ok, or, tech status is ok (as I understand it). This with RSICCONT table should tell us which all requests are there in the cube (that are available for reporting).

    Hope this helps!

    Sheen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 23, 2014 at 10:28 AM

    Hello Sajoy,

    There is another way to find out this.

    go to bex query designer screen.

    drag and drop the request id characteristic into colous panel and execute the query after that you can compare the request ids to your cube.

    This may helps you.

    Regards,

    Raghav.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 23, 2014 at 04:24 PM

    Hi Sajoy,

    If you want to see the your cube is ready for reporting or not then I think for any of 3 ways you need to cross check with manage tab of cube.

    1) Go to RSA1 -> Manage tabe -> request check for reporting sign in the infocube.

    2) whatever request Id you see in manage tab same will be present in following tables means till this request data you can report.

    3) You can open your cube in Bex analyzer and drg and drop the request ID you can see the same ID whatever you saw using above methods.

    Hope it will helpful.

    Regards,

    Ganesh Bothe


    cube.JPG (19.9 kB)
    cube1.JPG (35.2 kB)
    Add comment
    10|10000 characters needed characters exceeded