Hi all,
in the BO report, i have used a normal DB table and joined build the report. after a few days user came back with a new Chang asking the union for the new logic query. (tables and join everything is different)
in the same data provider needs to show the old and union along with updated SQL
Exam:
Data provider SQL shows like below
Normal table (existing DP query)
Union
New logic query (derive table)
so how to build this scenario
help on this
Thanks