The options are
1) Export your Sharepoint Lists into CSV files, then UNION them together.
2) Make extracts (files), then apply the recipe by Jonathan :
3) As s last resort, do blend your Sharepoint List datasources
using a Scaffold datasource as a Primary. By a Scaffold datasource
i mean a special hand-made datasource (it could be Excel or CSV)
which is a cross-product (contains every combination) of all unique values
of all the dimensions common in your Secondary datasources (SP Lists).
Think of it as a cube -- with cells populated by aggregates from your Secondary.
Hope it could help a bit.
Thanks so much Yuri! Let me try option 2 and 3 and see if I can make one of those work. Really appreciate the direction.
Mark, you're welcome.
Please reply if you have any questions / follow-ups.