My concern would be how do you limit the dataset to a reasonable size that Explain would work on a Subject Area? We have tables with several hundred million fact rows and dimensions with hundreds of thousands of rows. We would not want users to kick off an explain plan on that. Best approach is to run a data flow with…

Or at a minimum pre-populate an SR with all relevant instance details