Skip to Content
author's profile photo Former Member
Former Member

Problem with executing a Query in the QueryBrowser!

Hello together!

We are two students that have the first contact with SAP BI!

We are trying to make a Purchase-Controlling, but...

We have already made a DataSource (the SourceSystem is SAP R/3) with an InfoPackage and made a transformation to an InfoCube! We've mapped all the attributes und started with the DTP!

Then the SAP monitor informed us about a problem (No SID for Value PC of attribute 0BASE_UON; No SID for value PC of attribute 0PO_UNIT ==> Errorsource is the cube, type of operation VAL_SID_CONVERT; Name of operation: 0PO_UNIT Errorweight: 100)

==> We have no idea? What's the problem, because we haven't found such an attribute in our cube

==> But the process was completed

So there was data in our InfoCube. We've checked that!

Then we changed to the query designer und made a query!

But when we executed the query, BeXWeb told us that there is NO DATA!

Thank you in advance

Best regards

Pierre Isele

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2008 at 02:09 AM

    Hello,

    Goto RSRV and check the Master data test for SID and fix there errors.

    Goto the manage tab of the InfoProvider, make sure the request is eabled for reporting in the request tab

    Then goto LISTCUBE tcode and check your InfoCube/ODS data can be seen there.

    If the above are success then check the report

    Thanks

    Chandran

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2008 at 03:25 AM

    Hi Pierre

    Data which is coming for field Unit is not correct so it is giving an a Problem while loading data in cube.

    You will find Request tab in the manage of the cube, If that request is not available for the Reporting then it will not display data in the Report

    OR check the filter value in the query definition.

    Regards

    Rohit

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.