I have the following data in Excel spreadsheets:
I've looked at data blending, but believe filtering across all tables using dimensions that only exist in the parent table is not possible. Must the filter dimension exist in each table?
What kind of joins are you doing, and is there information in the multiple rows in the child sheets that you need, or just one value for a row in the parent? Does each child contain different columns, or just same columns with different data? If the latter, you need to look at unioning the children first, then joiining.