Radoslaw Lebkowski's Blog: The PPS Monitor & Analyze UDF Project (MAUDF)

For planning folks, this could probably be modified to read the metadata xml used in PerformancePoint Planning.

Microsoft Office PerformancePoint Server 2007 M&A stores all objects in it's metadata database (named PPSMonitoring in default configuration). Many of these objects are stored in SerializedXML column of the FCObjects table. So, it is very inconvenient to retrieve and search objects with criteria based od particular attributes (XPath / XQuery expressions would be necessary to perform the search).

But fortunately Nick Barclay has created great solution, which makes these operations much easier and straightforward.

This solution is called The PPS Monitor & Analyze UDF Project (MAUDF) and it is the project which delivers a set of useful views and UDF functions, which allow to access and retrieve metadata from PPSMonitoring database with using simple T-SQL queries.

Radoslaw Lebkowski's Blog: The PPS Monitor & Analyze UDF Project (MAUDF)