Hi All,
We have a scenario to avoid warning message “NO DATA TO RETRIEVE” from data provider while refreshing the report.
Step 1:
Create a Derived table (Derived Table) selecting SYSDATE from DUAL table.
Step 2:
Alias the same table with different name (Test) and join both the tables.
Step 3:
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.
Step 4:
Delete the alias table (test) from the data foundation and exclude the join form other context in the Data foundation.
Step 5:
Create object SYSDATE in the business layer and map the Derived filed Sysdate.
Steps 6:
To verify SysDate, create a Query in the IDT and check whether multiple queries are created for each context.
Steps 7:
Check System date is displaying even though other context not displaying data.
Step 8:
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.
Thanks
Sreeni
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
9 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |