A long time ago - February and March 2006 - Eugene Asahara has posted two very intersting articles about

• KPI Cause and Effect Visio Graph
• KPI Cause and Effect Graph - A View from the UDM into Relationships Between Information Workers

The "KPI Cause and Effect Visio Graph" is a very useful visualization tool to diskuss KPI´s with the prospective users whereas the "KPIRelationships sample application" is a very smart tool to control if all perspectives, KPI´s, etc are developed and have the right definitions.

This two articles are a really must-read and Eugene also provides the tools for download - so check it out!

This weblog is sponsored by FITS.
We support PASS Germany!

to be continued...
just to store the links - text will be added...

http://www.msftdwtoolkit.com/
Chapter 13 - Metadata Plan Reporting package:
http://www.msftdwtoolkit.com/ToolsandUtilities/Ch13/DW%20Metadata%20Browser%20Master.zip

This weblog is sponsored by FITS.
We support PASS Germany!

As Chris Webb posted here, there is a "SQL Server 2005 Business Intelligence Metadata Samples Toolkit", which brings up "Tools and Sample reports for Metadata Dependency Analysis of SSIS, SSAS", available for download for free.

Extract from the website:
"Microsoft SQL Server 2005 BI Metadata Samples provides tools and samples for analysing dependencies within and across SSIS and SSAS. The source code for the tools is provided.
The following are the components of this pack:
DependencyAnalyzer: a utility that scans SSIS packages and SSAS databases for enumerating metadata (objects, properties and dependencies).
DependencyViewer: a utility to view metadata organization & inter-dependencies (lineage/impact analysis).
Analysis Services Samples : sample SSAS packages that can be analyzed
Integration Services Samples: sample SSIS packages that can be analyzed
Report Model Samples (Report Builder): report builder model
Reports: sample reports built from metadata store
SQL: SQL script for creating metadata store"

Extract from the website:
"This white paper covers several interesting and unique methods for managing metadata in SQL Server Integration Services, Analysis Services and Reporting Services using built-in features including data lineage, business and technical metadata and impact analysis."

This weblog is sponsored by FITS.
We support PASS Germany!

With meta data getting more and more in the focus of BI-Projects you should look at http://www.metaintegration.net/

Here is a little self-explaning extract from there website "Meta Integration is the leading "Metadata Component Provider" to major database, data integration, business intelligence, repository, and modeling tool vendors. [...]"

They have also some publications online, especially the PDF-File Meta-Data Version And Configuration Management In Multi-Vendor Environments seems to be worth reading.

Because of having not tested the mentioned products any comment is appreciated!

This weblog is sponsored by FITS.
We support PASS Germany!