I have 2 OLEBD data sources that I need to connect to, at the same time! Is it possible?
They are an exact copy of each other, table structure, naming conventions etc are the same, just the information within them is for two different countries, and I need to compare the data held within each.
Is this possible, or do I have to export the information I need from one, and import it to the other to compare it?
Not all kinds of comparing the data would be possible with the following method but they is very simple and may reduce the amount of the (non-equal) data significantly. It's just a concatenation of the tables and then within the UI subtracting the results, for example something like this:
tx: load *, 't1' as Source from t1; concatenate(tx) load *, 't2' as Source from t2;
and then pulling the relevant (all) dimension-fields in a table-chart and using an expression like: