I already linked before to Chris Harrington's article about how it is possible to put data from Analysis Services cube into Office's ChartSpace chart component through XMLA. But if you don't want free Office solution (or perhaps it isn't free for you), or you don't want to use XMLA, or you want interactivity on the charts - you can use ChartFX for OLAP control. Here is what they say in their Web page:
| Chart FX OLAP is the most powerful, yet easy to integrate, .NET front-end OLAP for developers. Chart FX OLAP seamlessly integrates to Visual Studio .NET and provides the most advanced and intuitive user interface specifically built for OLAP pivoting, slicing and drilldown. Chart FX for OLAP supports ADO-MD and XML for Analysis |
Here is how this control looks in action against Foodmart 2000. I wonder how they decide which icons to show against every dimension (note the cute icons for Gender, Time and Store). I don't know how they do it, but just like I said in the post about MapInfo integration with Analysis Services, this is the exactly type of application which should take advantage of rich metadata which cube provides - i.e. dimension and level types exposed through schema rowsets. I.e. dimension can be marked as “Time“ or “Geography“, and level can be marked as “Gender“. Then application such as ChartFX should be able to discover dimension/level types and present the appropriate icon.
ChartFX OLAP can be downloaded from here: http://www.softwarefx.com/extensions/olap/