BPR 441 Microsoft Office Project Customized Reporting Capabilities
BPR 441 Microsoft Office Project: Customized Reporting Capabilities Using the Portfolio Analyzer Cube Philip Yuen Program Manager – Office Project Microsoft
EPM and Portfolio Analyzer Reporting is core to EPM Reap the benefits of Project by analyzing data Become a more mature EPM organization
Session Objectives Project Server Reporting Platform Client tools and Server architecture Extensibility model overview Portfolio Analyzer Extensibility Demo
Portfolio Analyzer What is it? Portfolio analysis and reporting tool in PWA What can it do for you? Analyze project costs over time Slice and dice by department or location Identify trends and problem areas
Portfolio Analyzer Architecture
Project Server Reporting Platform Project Transactional Tables Project Reporting Tables Portfolio Analyzer Cubes Analysis Services
Portfolio Analyzer Philip Yuen Program Manager Microsoft Office Project
Cube Building Architecture View Tables Views Publishing Service Cube Generation Create Staging Tables MSP_CUBE Cube Build Service (PROJOLAP. DLL) Portfolio Analyzer Cube
Common Extensibility Requests More reports using Project data Earned Value analysis Risks and issues for all projects Reports using data from external sources Services demand forecast analysis Budget allocation by dept. (Accounting system)
Extensibility Model View Tables Create Staging Tables Breakout 1: User. Staging. Tables. Update Views Publishing Service Cube Generation Cube Build Service (PROJOLAP. DLL) Breakout 2: User. OLAPUpdate Staging Tables MSP_CUBE Portfolio Analyzer Cube
Non Time-Phased Task Cube Leverage Task Earned Value Cube Create new SQL query Populate cube tables Create dimensions, measures, cube Register your DLL with Project Server
Task Earned Values Cube Philip Yuen Program Manager Microsoft Office Project
Building the Issues and Risks Cube Create new Issues and Risks cube tables Retrieve Issues/Risks data Transform data then populate tables Create dimension, measure, cubes Register your DLL with Project Server
Issues and Risks cube Philip Yuen Program Manager Microsoft Office Project
Tips and Tricks Trace function is useful for debugging with test harness Set SQL timeout for large database Combining multiple, separate extension DLL’s is tricky
Summary Endless possibilities Custom dimensions and measures External data sources; accounting system, CRM Analysis Services is our reporting platform for the future! Come to D 406 for Advanced Reporting Concepts
Additional Resources Project 2003 OLAP Cube extensibility SDK article and sample code http: //www. microsoft. com/downloads/details. aspx? Family. ID=ceed 7 e 60 -c 83 f-4 b 1 d-980 f 8298 c 0911 e 1 e&Display. Lang=en “Extending OLAP Cube Services in Microsoft Project Server” Project 2002 SDK article & sample code http: //www. microsoft. com/downloads/details. aspx? Family. ID=516 efcef-8 e 3 f-404 a-b 96 ebf 7 e 50 a 60481&Display. Lang=en
Questions
© 2004 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.
- Slides: 20