Here's the SQL to load the variable using your test data.  It'll produce a nice HMTL table (you can probably drop the header stuff.).

I'm a little rusty...

I can neither confirm nor deny what Russel said 🙂

It's a long time known issue:
https://blogs.msdn.microsoft.com/sqlperf/2007/04/29/set-up-ole-db-source-to-read-from-view-efficiently/

I've always used the "direct query' or from "variable" option,...

Here's an example of how I built an HTML table to sent via Database Mail in the past.  You should be able to adapt it to your purposes.

Anyone else getting timeout error messages when replying to posts?  It's happened a couple of times to me over the past few days.

Of course, I could be taking...

Gail has pretty much given you the answer to why that section is slow.

The coalesce on the join condition means indexes can't be used. The real problem...

I really appreciate everyone who's taken (taking) the time to help so please read with a thankful tone in mind.

I'm not sure if I'm not being clear or...

I've found Louis Davidson's Pro SQL Server Relation Design & Implementation and the Star Schema: The Complete Reference to be excellent resources.

Like Aaron said, you really need to...

Just started walking through the procedures / SSIS packages for the application I'm now responsible for at my new gig.

Why do so few developers care about maintainability?  There's...

From the looks of the error message there's a record in Fact Sales that has a value of '5685' in the CustID field and it can't find a record in...

Did you reprocess the dimensions after making the data change but before rerunning the cube processing?