Resultset of query is empty

[former_member411491]

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?

[former_member424914]

Hi All

Did you resove this issue? I have the same.

Help please.

Thanks,

Katherine

[former_member411491]

Hi Katherine,

Yes, i got the solution. Enable the External HANA view option in the general tab of the Composite Provider in BW Modelling.

Regards,

Sanjay Guha

[former_member411491]

capture1.jpg

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

Regards,

SG

[former_member274922]

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