1. No category

pmyers@solidq.com
Peter
Myers
Example
1. Introducing the Frosty Ice Cream company
2. Preparing the cube to store target values
3. Seeding target values based on historic actual
values using:
• Simple factor
• Data Mining (Time Series)
4. Contributing target values using Excel 2010
Multidimensional Development
MDX
expressions
−
−
−
−
−
−
StatusGraphic
TrendGraphic
ParentKpiID
Weight
AssociatedMeasureGroupID
CurrentTimeMember
Tabular Development
Tabular Development (Continued)
1. Defining an Analysis Services cube KPI
Excel
=CUBEKPIMEMBER(connection, kpi_name, kpi_property,
[caption])
Reporting Services 2012
PerformancePoint Services 2010
1. Delivering the Analysis Services KPI with:
• Excel 2010 and Excel Services 2010
• Reporting Services 2012
• PerformancePoint Services 2010
mva
http://northamerica.msteched.com
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn