Here is a useful utility to pull the tough-to-get-at PerformancePoint M&A repository data out.
Reuse & Recycle.
The PPS Monitor & Analyze UDF Project (MAUDF)
I've often wanted to be able access metadata within a monitoring server with greater ease. Querying the PPSMonitoring database is difficult because the more interesting pieces of information pertaining to a particular element are locked away within the SerializedXML column of the FCObjects table. Sure we can access the data in the SerializedXML column with XPath / XQuery but I really wanted to get stuck into some CLR stuff and figured UDFs would provide the greatest reuse, flexibility and query-ability.
I've created a series of CLR table-valued UDFs and created a home for it on Codeplex, a project that I have named MAUDF (taking a bit of inspiration from the ASSP project). Using the CLR the MAUDFs connect to the PPS Monitoring web service and extract pertinent metadata and return the results in a tabular format.
Nick Barclay: BI-Lingual: The PPS Monitor & Analyze UDF Project (MAUDF)
No comments:
Post a Comment