R – Connection between web parts in SharePoint

sharepointsharepoint-2007sharepoint-designerssas

I have a couple of questions regarding SharePoint 2007.

  1. Is it possible to bind a List View Web Part to SQL Analysis Services using SharePoint configuration?

  2. I have two webparts. When clicking one row of a List View Web Part, I want to show a chart in another web part based on the value on the clicked row. How can I achieve this functionality? Is this possible without writing any code, just by configuring?

Best Answer

What you want is the functionality delivered in PerformancePoint, which comes with a SharePoint E-Cal (although it was originally a separate product). The PPS Dashboard Item Web Part does exactly what you're looking for.