How to add value to EPM Reporting

1
How to add value to EPM Reporting
2
CPS

• Over 10 years Microsoft Project Enterprise
  solutions implementation experience
• EPM Solution Presenters for Microsoft
• Product Association History
• European Enterprise Project
• Beta Programme for 2002 / 2003 /
• Microsoft's Rapid Adoption Programme for Project
  2002 / 2003
• Customisation of Project Central, 2002 and 2003

3
Contents

• OLAP What is it ?
• Custom Cube data structure
• Portfolio Analyser Advanced
• WSS Reporting Site

4
OLAP What is it ?

• On Line Analytical Processing
• Why do you want one?
• Remove the use of SQL query language for the end
  user
• Drastically reduce the load on your SQL Server
• OLAP and EPM

5
Standard OLAP Build Process
Initiation Scheduled Cube Build from PWA
Build Virtual (Bridging) Cube
Build Resource Availability Cube
Build Project Dimensions Cube
Build Staging Tables
Standard Cube
Also used in PWA Resource Availability
6
Breakout or DTS

• EPM Breakout call
• Pros
• No extra cubes are generated
• Code encapsulated in a series of DLLs
• Cons
• Requires 5 skill bases
• SQL Server
• SQL Analysis Services
• Visual Basic
• EPM Breakout Call
• EPM Administration
• Issues when client restructures the Enterprise
  Global Custom fields/Outline Codes
• Hard to identify source of Issues
• Using standard SQL DTS
• Pros
• The manual configuration can be documented and is
  easily reproducible
• Can be easily maintained
• Only Requires 3 skill bases
• SQL Server

7
Custom OLAP Build Process
Initiation Scheduled Cube Build from PWA
Build Virtual (Bridging) Cube
Build Resource Availability Cube
Build Project Dimensions Cube
Build Staging Tables
Standard Cube
Build Custom Projects Resources Cube
Creation Custom Fact Table Creation
Initiation Scheduled Custom Cube Build
Initiation Scheduled Stored Procedure
Custom Cube
Required for Task Codes and Custom Fields
8
Custom Cube data structure

• SQL Analysis Manager
• Used to manipulate the data contained in the Cube
• Used to manipulate the presentation of data
• Used to add additional calculated fields

9
Portfolio Analyzer - Advanced

• Reporting against a Custom Cube
• Reporting against any data source

10
WSS Tuned Reporting Site

• What Can you add to WSS ?
• How can you tune EPM for WSS

11
Closing Slide

• For more Information please contact
• Sacha Cohn on Sacha.Cohn_at_cps.co.uk
• Chris Pond on Chris.Pond_at_cps.co.uk