Skip to Content

Resultset of query is empty

capture1.jpgcapture.jpg

Hi All,

I am trying to Create Report on SAC on top of Bw4HANA Live connection. I pull the data from Bw7.4 to Bw4hana using ADSO, DTP, transformation, etc. I can see the data on ADSO. On top of ADSO, I created CP(Composite Provider), but when I am creating simple on top of CP, I am not able to see any data.

I tried to mage query on top of CP with both join and union condition but result is same.

I tried to create a query on top of ADSO still result is same( I can see the data in Manage -Active Table)

Please suggest me what can be the cause?

capture1.jpg (22.0 kB)
capture.jpg (63.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 21 at 01:18 PM

    Hi Sanjay,

    Do you see an output if you execute the ADHOC query of the Composite Provider in transaction RSRT?

    Guidelines for Error Analysis

    Guided Answers: Troubleshooting BExQueries on HCPR


    WIKI ADHOC QUERY:

    https://wiki.scn.sap.com/wiki/x/KALFFw

    WIKI TRANSACTION RSRT

    https://wiki.scn.sap.com/wiki/x/EwGIFQ



    Regards,
    Matthias

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 27 at 04:51 AM

    capture1.jpg

    Yes i Tried as you suggested. But the result is same.

    Regards,

    SG

    Add comment
    10|10000 characters needed characters exceeded