I'm testing sharepoint 2010 and like all the new features but mostly interested in BI Dashboard.
We are using web based infopath form that the users fills out and save in sharepoint. In MOSS 2007 we are using third party charts that represents the data logged in the list that contains infopath forms.
I've tested sharepoint2010 chart web parts with the list and it works fine but because infopath forms collects so much data we want to use drill down charts. I've started using PerformancePoint Dashboard designer but as you know it only allows to
create chart for Analysis services.
so my questions are:
1. Is there a way to create drill down charts using list as a data source?
2. Is there a way to export data from list to analysis services? (This needs to be automatic task)
3. Are there any third party tools that I could use to create drill down charts in sharepoint2010?