I have one part of data in datasource-1 and another part of data in datasource-2. How to combine the
I have one part of data in datasource-1 and another part of data in datasource-2.
For example,
There are class 1-6 in a school. To some consideration, the data for class 1-3 are in datasource-1 and data for class 4-6 are in datasource-2. The data structure are the same in datasource-1 and datasource-2.
My question is how to generate BI reports to show data in class 1-6 as a whole.