It was a great tool that was discontinued. It should reappear in Access!
Users should be used to “discover” data… and only afterwards, go into Excel or Reporting Services.
If the cube is decent (Levels / AVG’s, MAX’s, etc), it’s a really cool thing. it’s shocking that we don’t promote it as real world tool for execs and I hope MS keeps upgrading it.
Note: Not saying to show any MDX that is advanced and MDX can be done manually or in Proclarity (not Panorama).
Maybe OLAP data is a bit of a move away from core stuff but then again so is SharePoint integration in Access 12 and that does not seem to be a bad thing.