How to avoid ” no data to retrieve ” from query popup
We have a scenario to avoid warning message “NO DATA TO RETRIEVE” from data provider while refreshing the report.
- De Approvals is one of the Data Provider using in the report. Objects listed in one of the data provider(De Approvals) do not have data retrieved.
- We tried to avoid warning message by checking options in the information design tool and WebI, however it’s not possible because it’s by design in business objects.
- We tried to change the code at the SDK level, but maintenance issue’s will comes with any upgrade or patch update, to make sure the SDK changes are not overwritten.
- So suppressed pop up warning message as workaround with below steps.
Create a Derived table (Derived Table) selecting SYSDATE from DUAL table.
Alias the same table with different name (Test) and join both the tables.
Create a context (Date) using the two tables (Derived Table and Test) then select the join (Derived Table”.SYSDATE” = Test.”SYSDATE”) and change the expression as 1=1.
Delete the alias table (test) from the data foundation and exclude the join form other context in the Data foundation.
Create object SYSDATE in the business layer and map the Derived filed Sysdate.
To verify SysDate, create a Query in the IDT and check whether multiple queries are created for each context.
Check System date is displaying even though other context not displaying data.
And then use the SYSDATE object in all the Data providers and then run the report. report don’t display the No date retrieve warning message because sysdate always have current system date.
Hope this helpful.