Hi Cody. Lots of good questions. Here goes...

1. Backups. I like backups. Let's say something goes woefully wrong with your data warehouse that feeds SSAS - it would be nice...

Try making the textboxes in your heading span the entire width of the report. Let's say you have 2 textboxes & a tablix like this...

...

Martin,

I just blogged about this very issue at: http://www.sqlchick.com/entries/2011/4/4/pros-and-cons-stored-proceduresvs-embedded-queriesvs-views-i.html

Hope it helps.

Melissa

You might also try putting both Tablix regions within one Rectangle.