Ten Characteristics of a Good KPI

There’s a lot of talk these days about key performance indicators (KPIs). They are the backbone of scorecards and dashboards, which have become an irresistible way for organizations to present performance information to executives and staff. Unfortunately, BI developers seem to focus more on creating visual metaphors (dials, gauges, arrows, etc.) than understanding what constitutes a good KPI that delivers long-term value to the organization.   Part of the problem is that people use the... Read more

SQL 2008 February CTP available

Microsoft has announced the release of a new feature complete SQL Server 2008 CTP, try it online for free on the SqlServerBeta site or at the MS connect site. I’ve played with it a little and found the new report designer to still be a preview version with some strange behavior. BIDS seems stable and the report project environment  is nice, too bad the wizard isn’t there (yet i hope). The new reporting services configuration manager had... Read more

Opening a Cube from Sharepoint issues

I made a connection to AS in Excel and published this connection as a ODC file to SharePoint as mentioned in a previous blog post. But when i openend the file connection by clicking itm i got a warning: “Excel was unable to get necessary information about this cube. The cube might have been reorganized or changed on the server”.   After some searching with MS i found a solution: http://support.microsoft.com/kb/931388. I tried tuning the... Read more

Using Analysis Services data in Excel Services

When you want to analyse a cube in sharepoint from excel services you need to create a data connection file and publish it to SharePoint, see the following Blog post for a walk through: http://www.sharepointblogs.com/tonstegeman/archive/2007/03/13/using-analysis-services-data-in-excel-services-part-3-create-and-test-an-excel-sheet.aspx One note, it is stated in the above walk through you need to save the file and upload it to the data connection folder, but its easyer to save it to the data connection folder at once. Read more

Using Toggling in Reports

When using the Report designer you can enable fancy toggeling of fields. Once you know the trick its realy easy.   Make sure you have multiple fields in rows or columns. Select the field you want to toggle and go to edit group and the tab visibilty, put it on visiblity hidden and check the “visibility can be toggled by another report item” box and select the parent report item you want to toggle. Thats all there... Read more