Transcript The Hidden Riches behind Microsoft Dashboards, Scorecards, and

Thavash Govender
Senior BI Consultant
iSolve Business Solutions
BIN306
Objectives
Inform on PPS futures
Use web page reports
Access scorecard cell data
Query M&A repository
Inspiration
Inspiration
Expectations
Mine
SQL Server BI
PPS M&A
Basic .NET
Yours
Level 300
A bit of .NET code
What about that Jan. announcement
BI Roadmap Announcement
Today
2010
PerformancePoint
Server 2007
PerformancePoint
Services in
Microsoft
SharePoint Server
2010
PPS Product Licensing Roadmap
Today
2010
(effective 01 APR 2009)
Monitoring
Analytics
PPS 2007
As an entitlement of
MOSS 2007 Enterprise
CAL Software Assurance
SharePoint 2010
Enterprise CAL
…the unsung hero of PPS
The Mighty
Web Page
Report
Web Page Reports
Send the user to a web page
Available since BSM 2005
“catch all” report
Simple, eh?
...too simple?
One configurable property
A static URL!
When is a static URL useful?
When it refers to a custom web page
What can a custom web page do?
…as long as we
provide context
Context Communication?
Filter Links
Request.Params
Request.Params
Standard HTTPRequest property
Communication between pages
Collection of form elements,
cookies, server variables etc.
Filter Link Pathways
Item Type
Filter
Scorecard
Report
Outbound
Inbound






Communicators
Filter Links += Request.Param items
Outbound
Custom Page Requirements
What to look for
Filter link data
Where to find it
Request.Params
What to do with it
…it depends
How is it done?
MyCustomPage.aspx
1
2
3
4
User
Interaction
Request.Params
Custom page
Web Page Reports
Thavash Govender
Senior Solutions Architect
iSolve Business Solutions
Consider the Possibilities
Some Suggestions
Filter link debugging
Web page redirection
Call 3rd party web apps
…anything
Commentary Collection
Q4 2008
Bikes
Inspired Web Page Reports
“catch all” report
Do just about anything
…and how to get at it
The Eternal Question
Scorecard Cell Data
Show Details functionality
Passing Scorecard Cell context to reports
Show Details
Metrics use SSAS base measures
Grant cube Drillthrough access
Metric calculation = “Source Data”
Passing Scorecard Cell Context
Drill down on this cell
Scorecard Cell Display Value
Scorecard Cell XML
Rows
Columns
Scorecard Cell XML Data
[Product].[Category].[Bikes]
[Date].[Calendar Quarter].[Q1 CY 2003]
1
2
3
Accessing Scorecard Cell Data
Nick Barclay
Senior Solutions Architect
Avanade
Inspired Scorecard Cells
Easy Show Details
functionality
Use cell XML to
provide context
…and how to get at it
Where is my M&A metadata?
PPSMonitoring.dbo.FCObjects.SerializedXML
SerializedXML
Why would I want to query It?
“Can you provide a report for…
the banding thresholds for that KPI?”
all the elements currently published to server
ABC?”
annotations that have been added to a
scorecard?”
Accessing Element Metadata
SSMS: T-SQL / Xpath
SELECT
CONVERT(xml, SerializedXml )
.query('/Kpi/Properties/BpmProperty[./@DisplayName="De
scription"]')
.query('data(/BpmProperty/@Text)') AS KPI_Description
FROM FCObjects
.NET: PPSMonitoring Web Service
The MAUDF Project
Monitor Analyze User Defined Functions
Provides
T-SQL access to M&A element metadata
Using
CLR Table-Valued UDFs
Available
http://www.codeplex/maudf
Query SerializedXML with T-SQL
CLR Table Valued UDFs
Queried with T-SQL
Use CROSS / OUTER APPLY joins
Accept parameters
Full access to .NET
SELECT *
FROM ElementMetadata() e
CROSS APPLY KpiMetrics(e.ElementID) m
WHERE e.ElementType = 'KPI'
How It Works
SELECT e.*
FROM ElementMetadata() e
CROSS APPLY KpiMetrics(e.ElementID) m
WHERE e.ElementType = 'KPI'
MAUDF
CLR
PPSMonitoring
PPSMonitoring
The Functions
Scope
Function
Element
Metadata, Memberships, CustomProperties
Indicator
Metadata, Levels
KPI
Metrics, Thresholds
Data Source
Metadata
Scorecard
Metadata, KPIs, Annotations
Report
Metadata
Dashboard
Items
MAUDF
Inspired Element Meta Data
Open source MAUDF
Query with T-SQL
Access other web
services
Hidden Riches We’ve Discovered
The mighty web
page report
Scorecard cell interaction
MAUDF
Resources
www.microsoft.com/teched
www.microsoft.com/learning
Sessions On-Demand & Community
Microsoft Certification & Training Resources
http://microsoft.com/technet
http://microsoft.com/msdn
Resources for IT Professionals
Resources for Developers
www.microsoft.com/learning
Microsoft Certification and Training Resources
Related Content
BIN202 - Dashboards and Scorecards: Technical Overview for IT Professionals and
Developers
BIN307 - Using MDX for Enhanced Scorecards and Dashboards
BIN203 - Democratizing Business Intelligence: Delivering BI to the Masses
BIN02 - HOL Dashboards End to End
Track Resources
http://blogs.msdn.com/performancepoint
http://www.microsoft.com/bi/
http://thavash.spaces.live.com
http://www.codeplex.com/maudf
10 pairs of MP3
sunglasses to be won
Complete a session
evaluation and
enter to win!
© 2009 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should
not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS,
IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.