SSAS MDX Measures on Rows in SSRS

Sooner or later Reporting Services users who create reports against Analysis Services data will encounter one of the product limitations: you can't put measures on rows when you design your report. Or can you....??

For example, the following type of query is rejected by SSRS when designing a report: