At work, I'm devoting a fair amount of my time to SQL BI concepts lately. One of the exciting concepts (there are many, believe me) of SSAS on SQL 2005 is Key Performance Indicators. A KPI is the creme de la creme of all the data aggregations. It's the final display of knowledge extracted from the vast amount of data to answer questions like "Based on such and such criteria, are we profitable?".
Since KPIs are mostly for non-techies, it's best to display them in a dashboard like scenario, where SharePoint is a good example. A handy newcomer in dashboard scene is Vista Sidebar, and displaying KPI data on the Sidebar was the most logical exercise for Sidebar development for me with the release of Vista:
<Canvas x:Name="kpiCanvas" />
Here's the code for the WPF/E thing (gadget? applet? app?). Note that, everything's fine in IE:KPIDS.rar (7.21 KB)
- WPF/E currently doesn't like .gif images in IMAGE tags. <Image Source="star.png" /> is fine but <Image Source="star.gif" /> fails without an error, or it's the case for me.
- I lost (accidentally overriden) the source for KPI sidebar gadget (the one without WPF/E, two images above) but you can easily build one from the given source. Change "createKPI" in kpiLibrary.js to render to html instead of xaml.
- createFromXaml is a nice method but, we'll have programmatic access to the object model won't we?
- Follow the steps below to setup remote XMLA access to SSAS through web services. It's required to access KPI data remotely:
Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows Server 2003.