SAP BO - What are the possible reasons for 'no data to retrieve' in a webi report?

[former_member5]

What are the possible reasons for 'no data to retrieve' in a webi report?

SAP BusinessObjects Business Intelligence platform 

SAP BusinessObjects - Web Intelligence (WebI) 

[jemstar]

Only one reason. The SQL generated by your web intelligence query does not return any data. Copy the SQL and paste it into your native database query tool anf troubleshoot from there

[former_member5]

Is this possible if there is a connection issue?

[Joe_Peters]

It means that the query that WebI executed in the back-end database did not return any rows.  But that can happen for any number of reasons, including:

• The conditions in the query simply don't match any records in the database.  
• The query included a prompt, and the value entered for the prompt is not valid or does not exist in the database
• The query contains an illogical combination of conditions (ex., "Region Equals 'East' And Region Equals 'West'"
• Objects selected in the query (from results and/or conditions) result in tables being combined that weren't intended to be in the same query
• Row-level security is in use, and the person executing the query does not have sufficient permissions
• Passthrough authentication is used, and the person executing the query does not have sufficient permissions in the database
• One or more tables in the database are empty

[deshmukh]

nicely summarized

[jemstar]

The fact that you can refresh the report proves you have connectivity to the database used in the connection of the universe.

The answer here is the SQL being produced by the web intelligence query - it may contain incorrect joins or incorrect join types or may be imposing a restriction in the where clause that you are unaware of

James