For integration into your own applications I found an AMAZING tool at :
They offer .NET components for your use in both ASP and WinForm applications.
A close second (and one I recommend due to price) is XtraPivotGrid. If you get their suite editions there is no beating the price.
STANDALONE DESKTOP CASE
Their Cube Player is the best MDX editor you can find. For that alone it is worth it!