Transcript Introduction to Project 2002

How to add value to EPM
Reporting
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
Contents
OLAP – What is it ?
Custom Cube data structure
Portfolio Analyser – Advanced
WSS Reporting Site
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
Standard OLAP Build Process
Initiation
Scheduled
Cube Build
from PWA
Build
Resource
Availability
Cube
Also used in
PWA Resource
Availability
Build
Staging
Tables
Build
Project
Dimensions
Cube
Build
Virtual
(Bridging)
Cube
Standard
Cube
Breakout or DTS
EPM Breakout call


Pro’s
 No extra cubes are generated
 Code encapsulated in a series of DLL’s
Con’s
 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

Pro’s
 The manual configuration can be documented and is easily reproducible
 Can be easily maintained
 Only Requires 3 skill bases:




SQL Server
SQL Analysis Services
EPM Administration
Con’s
 An extra set of cubes is generated, though only the custom set are referenced
 Not a packaged solution
Custom OLAP Build Process
Initiation
Scheduled
Cube Build
from PWA
Custom
Cube
Build
Resource
Availability
Cube
Build
Custom
Projects &
Resources
Cube
Build
Staging
Tables
Initiation
Scheduled
Custom
Cube Build
Build
Virtual
(Bridging)
Cube
Build
Project
Dimensions
Cube
Creation
Custom Fact
Table
Creation
Standard
Cube
Initiation
Scheduled
Stored
Procedure
Required for Task Codes
and Custom Fields
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
Portfolio Analyzer - Advanced
Reporting against a Custom Cube
Reporting against any data source
WSS Tuned Reporting Site
What Can you add to WSS ?
How can you tune EPM for WSS
Closing Slide
For more Information please contact:
Sacha Cohn on [email protected]
Chris Pond on [email protected]