More discussions in BusinessObjects Integration KitsWhere is place located?
    6 Replies Latest reply: Nov 19, 2012 3:35 PM by Muhammad Toor RSS

    No data to retrieve from query

    Usha Reddy
    Usha Reddy
    Jun 8, 2012 12:37 PM
    Currently Being Moderated

    Hello All

     

     

    I'm working on BO 3.1 webi reports which are based on OLAP universe, I'm getting "No data to retrieve from query" but when i can check the query in the BW from Bex analyzer it returns data .

     

    Any help much appreciated.

    • 697 Views
    • Re: No data to retrieve from query
      Ravi Shankar
      Ravi Shankar Jun 8, 2012 1:12 PM (in response to Usha Reddy)
      Currently Being Moderated

      Hi Usha,

       

      This error occurs due to Universe connections can be changed and redirected to different database with similar structures but less or different data. No integrity or structure errors could be raised. This might also happen when moving a universe between environments and expecting the universe connections in all environments to be the same.

    • Re: No data to retrieve from query
      Avinash Verma
      Avinash Verma Jun 12, 2012 12:47 PM (in response to Usha Reddy)
      Currently Being Moderated

      Hi Usha,

      • Test Universe connection with BW the server must be responding.
      • Check Integrity of Universe on which you have created WebI report it should be "OK" (Universe designer-> tools -> Check Integrity).
      • Refresh structure of the universe. (Universe designer-> view -> Refresh structure)
      • Export universe (Universe designer->File -> Export) and then check WebI report.

      hope this will resolve your problem.

       

      Regards,

      Avinash

      • Re: No data to retrieve from query
        Usha Reddy
        Usha Reddy Jun 13, 2012 10:06 AM (in response to Avinash Verma)
        Currently Being Moderated

        Thank you so much for answering  Ravi Shankar and Avinash Verma

         

        We have already checked the universe connections and check Integrity ,everything was working fine still we were getting same thing i.e. "No data to retrieve from query".

         

        Even we tried splitting the queries in the webi report and merge them and build the report but it didn't worked out as we were facing many errors.

         

        After checking all the things,we started  building the report from scratch pulling one by one object ,while doing this we have encounter the error " A database error occurred.The database error text  is : Error in MDDataSetBW.GetcellData.No more memory / roll storage space available ". In order to come out this error we started including filters/prompts and few measures(even though in our report requirements we don't need any measures) and that's how we got the data in our report.

         

        Regards

        Usha

        • Re: No data to retrieve from query
          Laxminarayana Kidambi
          Laxminarayana Kidambi Jun 19, 2012 11:33 AM (in response to Usha Reddy)
          Currently Being Moderated

          Hello Usha,

           

          BO XI R 3.1 using uses mdx query to get data from BW. Here is what I recommend

           

          1. Try to run the using webi rich client

          2. From the machine where you are running webi rich client enable the mdx logs

          3. If you are running the report  from Infoview you need to enable mdx trace on the server box.

          4. The locations are different if you are using a 64 bit or 32 bit machine

          5. Once the mdx query is generated, go to the the workbench and execute 'mdxtest'(dont include quotes) transaction

          6. You will see a screen on the right to paste the query, execute the query in xml mode. IF this gets data then there is an issue with the BO retrieving data, if you dont see any data here you will need to check with the BW query design.

           

           

          Check SAP #1235111 – Enabling MDX/MDA tracing

           

          Regards,

          Laxminarayana

    Actions