Check infocube and verify that all request in there are reportable

[Former Member]

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.

[Former Member · Accepted solution]

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

[former_member183012]

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

[Former Member]

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.