If you mean a multidimensional SSAS cube as a source then I'd agree - can't see where there would be any benefits vs. there warehouse.

But there are many benefits to using a tabular SSAS implementation with Excel Pivot as a front end: higher RAM and disk resources on a server vs an end users workstation, build once - share with many, disaster recovery implications, etc...