Microsoft Project ServerMicrosoft Project ServerEnterprise Project SolutionEnterprise Project Solution

Shawn TngShawn TngRegional Technology ManagerRegional Technology ManagerMicrosoft Asia PacificMicrosoft Asia Pacific

AgendaAgenda

Product DefinitionProduct Definition Project GuideProject Guide Project Server ArchitectureProject Server Architecture Resource CenterResource Center Portfolio AnalyzerPortfolio Analyzer SharePoint Team Services IntegrationSharePoint Team Services Integration Object Link ProviderObject Link Provider Project Data ServiceProject Data Service

Product DefinitionProduct Definition

Rich Client:Rich Client: Microsoft Project StandardMicrosoft Project Standard Microsoft Project ProfessionalMicrosoft Project Professional

Microsoft Project ServerMicrosoft Project Server Browser ClientBrowser Client

Microsoft Project Web AccessMicrosoft Project Web Access

Project GuideProject Guide

New in MSP2002 Pro and StdNew in MSP2002 Pro and Std Integrates HTML pages with MSP ClientIntegrates HTML pages with MSP Client Comprises of:Comprises of:

Project Guide ToolbarProject Guide Toolbar Side PaneSide Pane Main View AreaMain View Area

Project GuideProject Guide

The Project Guide Toolbar The Project Guide Toolbar Command bar for top-level navigationCommand bar for top-level navigation Contains buttons for goal areas in the Contains buttons for goal areas in the

Project Guide Project Guide

Side Pane Side Pane Displays tasks within each goal area of Displays tasks within each goal area of

the Project Guidethe Project Guide

Main View Area Main View Area Views and pages depend on the task Views and pages depend on the task

selected in the side paneselected in the side pane

Customising Project GuideCustomising Project Guide

An instance of web browser control is An instance of web browser control is hosted with each active project dochosted with each active project doc Default page: mainpage.htmDefault page: mainpage.htm

Information structure and content for Information structure and content for PG is defined by XML docPG is defined by XML doc Default: Gbui.xmlDefault: Gbui.xml

To customise PG, change/replace To customise PG, change/replace Gbui.htm Gbui.htm

Indicate change in Tools->Options-Indicate change in Tools->Options->Interface>Interface

Gbui.XML StructureGbui.XML Structure

<element name="GBUIStructure"><element name="GBUIStructure">

<complexType> <complexType> <element ref="ViewChanges" maxOccurs=1 > <element ref="ViewChanges" maxOccurs=1 >

<element ref="PageChanges" maxOccurs=1 > <element ref="PageChanges" maxOccurs=1 >

<element ref="GoalArea" maxOccurs=* ><element ref="GoalArea" maxOccurs=* >

</complexType></element></complexType></element>

Gbui.XML StructureGbui.XML Structure

ViewchangesViewchanges Defines how PG responds when user change Defines how PG responds when user change

views in MSP Proviews in MSP Pro Eg. Change Gantt Chart View to Resource ViewEg. Change Gantt Chart View to Resource View

PagechangesPagechanges Defines how PG responds when the user display Defines how PG responds when the user display

MSP Web Access pages from MSP Server within MSP Web Access pages from MSP Server within MSP ProMSP Pro

Eg. The new “Collaboration” menuEg. The new “Collaboration” menu GoalareaGoalarea

Defines the PG side panes displayed for the Defines the PG side panes displayed for the task/activities in that goal area (ie., defines task/activities in that goal area (ie., defines content + structure of PG)content + structure of PG)

Eg. “Define the Project” within “Task”Eg. “Define the Project” within “Task”

Project Guide Project Guide CustomizationCustomization

demodemo

Microsoft Project ServerMicrosoft Project Server

Project Task ManagementProject Task Management Project Progress UpdatingProject Progress Updating Issues ManagementIssues Management Project and Portfolio ReportingProject and Portfolio Reporting Status ReportingStatus Reporting Resource ManagementResource Management Document ManagementDocument Management

Project Server ArchitectureProject Server Architecture

MS

Pro

ject

Ser

ver

Illustration: Illustration: MSP Professional Startup ProcessMSP Professional Startup Process1.1. MSP Pro startsMSP Pro starts2.2. User chooses local/global profilesUser chooses local/global profiles3.3. MSP Pro makes request to PDS to open global MSP Pro makes request to PDS to open global

templatetemplate4.4. PDS queries MSP Server for permissionPDS queries MSP Server for permission

a.a. OKOK

5.5. PDS prepares SQL Server views for MSP ProPDS prepares SQL Server views for MSP Pro6.6. PDS passes connection string info to MSP Pro PDS passes connection string info to MSP Pro

using XMLusing XML7.7. MSP Pro serialiser creates ODBC connection to MSP Pro serialiser creates ODBC connection to

SQL Server views in the MSP Server DatabaseSQL Server views in the MSP Server Database8.8. MSP Pro loads Enterprise Global Template in MSP Pro loads Enterprise Global Template in

memorymemory9.9. Connection is terminated when read is finishedConnection is terminated when read is finished10.10. MSP Pro opens local global file + toolbar/menus MSP Pro opens local global file + toolbar/menus

from local global file into memoryfrom local global file into memory

Project Server DatabaseProject Server Database

Microsoft Project Server DatabaseMicrosoft Project Server Database

Microsoft Project Microsoft Project Web Access TablesWeb Access Tables

(MSP_WEB_*)(MSP_WEB_*)

Microsoft Project Microsoft Project 2002 Tables2002 Tables

(MSP_*)(MSP_*)

View TablesView Tables(MSP_VIEW_*)(MSP_VIEW_*)

Cube TablesCube Tables(MSP_CUBE_*)(MSP_CUBE_*)

Resource CenterResource Center

Allows managers to view and modify Allows managers to view and modify settings for enterprise resourcessettings for enterprise resources

Allows for accessing detailed Allows for accessing detailed assignment and availability informationassignment and availability information

Resource CenterResource Center

demodemo

Portfolio AnalyzerPortfolio Analyzer

Reports available at portfolio, project, and Reports available at portfolio, project, and resource levels resource levels

Requires Microsoft Project Professional and Requires Microsoft Project Professional and Microsoft® SQL Server™ 2000 Analysis Microsoft® SQL Server™ 2000 Analysis Services Services

Uses components from the 3-tier:Uses components from the 3-tier: Database: SQL Analysis Services to create an Database: SQL Analysis Services to create an

OLAP CubeOLAP Cube Middle: Portfolio Analyser Cube Generation Middle: Portfolio Analyser Cube Generation

Service create a set of facts & dimension tables Service create a set of facts & dimension tables based on data in MSP Server Databasebased on data in MSP Server Database

Client: Use OWC (PivotTable, PivotChart Client: Use OWC (PivotTable, PivotChart controls bound to the OLAP cube)controls bound to the OLAP cube)

Portfolio AnalyzerPortfolio Analyzer

demodemo

Integration with STSIntegration with STS

STS works as a component of the MSP STS works as a component of the MSP ServerServer

MSP Server automatically configure STSMSP Server automatically configure STS MS Windows user a/c must be usedMS Windows user a/c must be used Enables Document and Issues features in Enables Document and Issues features in

Project Web Access to be usedProject Web Access to be used Modify STS schema files to include doc Modify STS schema files to include doc

properties, document library detailsproperties, document library details Issue list is customised STS list fileIssue list is customised STS list file Link between docs/issues and project/tasks Link between docs/issues and project/tasks

information stored in MSP Server databaseinformation stored in MSP Server database

Project Server with Project Server with SharePoint Team SharePoint Team ServicesServices

demodemo

Extensibility Using OLPExtensibility Using OLP

Object Link Provider object Object Link Provider object (Projobjprov.dll) resides in middle layer (Projobjprov.dll) resides in middle layer of MSP Serverof MSP Server

Exposes interface methods for linking Exposes interface methods for linking docs and issues to project and tasksdocs and issues to project and tasks

Link info stored in MSP ServerLink info stored in MSP Server External object can be associated with External object can be associated with

project/tasks as long as the unique ID project/tasks as long as the unique ID of the object can be expressed as URL, of the object can be expressed as URL, XML or Table IDsXML or Table IDs

Provides the interface for sophiscated Provides the interface for sophiscated doc mgt/issue tracking processdoc mgt/issue tracking process

Object Link ProviderObject Link Provider

SQL ServerSQL Server

Table:Table:ObjectsObjects

OLPOLP

Microsoft Project Server 2002Microsoft Project Server 2002

IISIIS

Table:Table:ObjectObjectLinksLinks

SharePointSharePointTeam Team

ServicesServices

Microsoft Microsoft Project Web Project Web

AccessAccess

Project Data ServiceProject Data Service Act as a gateway to receives requests to Act as a gateway to receives requests to

access or update enterprise data access or update enterprise data Request/Reponse to PDS are made thru’ Request/Reponse to PDS are made thru’

XML interface (using SOAP)XML interface (using SOAP) PDS opens a connection to the Microsoft PDS opens a connection to the Microsoft

Project database on behalf of the client, Project database on behalf of the client, authenticates the client and provides access authenticates the client and provides access to the Microsoft Project data that particular to the Microsoft Project data that particular client is authorized to viewclient is authorized to view

Provides a SOAP interface for third-party Provides a SOAP interface for third-party client applications to access Microsoft client applications to access Microsoft Project Server features Project Server features

Provides an extensibility model for Provides an extensibility model for extending of Microsoft Project Server extending of Microsoft Project Server functionalityfunctionality

Project Data Service: GatewayProject Data Service: Gateway

SQL ServerSQL Server

ViewsViews TablesTables

ClientClientApplicationApplication

Microsoft Microsoft Project Data Project Data

Service Service (PDS)(PDS)

Microsoft Project Server 2002Microsoft Project Server 2002

IISIIS

Accessing Microsoft Project DataAccessing Microsoft Project Data

To access Microsoft Project data To access Microsoft Project data Log on to the Microsoft Project Server. Log on to the Microsoft Project Server. Call the PDS to request the database connection Call the PDS to request the database connection

information. information. Make a connection to the Microsoft Project Server Make a connection to the Microsoft Project Server

database using that information and gather the SQL database using that information and gather the SQL Process ID (SPID) for that connection. Process ID (SPID) for that connection.

Call the PDS to request access to the project or resource Call the PDS to request access to the project or resource that the client needs to access and pass along the SPID that the client needs to access and pass along the SPID from the previous step. from the previous step.

Make queries against the appropriate set of Microsoft SQL Make queries against the appropriate set of Microsoft SQL Server™ views to gather and/or update the required Server™ views to gather and/or update the required information. information.

Call the PDS when the access is no longer required to Call the PDS when the access is no longer required to maintain the security of the data. maintain the security of the data.

Disconnect from the Microsoft Project Server database. Disconnect from the Microsoft Project Server database.

SummarySummary

Discuss Enterprise Platform for Project Discuss Enterprise Platform for Project ManagementManagement

Understand Project Server ArchitectureUnderstand Project Server Architecture Discuss Project Server Use and Discuss Project Server Use and

Demonstrate CustomizationDemonstrate Customization

For More Information…For More Information…

EPM Trial CDsEPM Trial CDs http://msdn.microsoft.com/library/

default.asp?url=/nhp/default.asp?contentid=28000445

www.microsoft.com/office/projectwww.microsoft.com/office/project White Papers:White Papers:

““Microsoft Project 2002 Project Guide Microsoft Project 2002 Project Guide Architecture and Extensibility”Architecture and Extensibility”

““Microsoft Project 2002 Enterprise Project Microsoft Project 2002 Enterprise Project Management Architecture Guide”Management Architecture Guide”

““SharePoint Team Services Integration SharePoint Team Services Integration Architecture and Extensibility”Architecture and Extensibility”

Q&AQ&A

Don’t forget to turn in your evals!Don’t forget to turn in your evals!

如果您有任何问题，请加入如果您有任何问题，请加入微软中文新闻组微软中文新闻组继续讨论继续讨论

加入微软中文新闻组加入微软中文新闻组http://www.microsoft.com/china/communityhttp://www.microsoft.com/china/community

© 2002 Microsoft Corporation. All rights reserved.© 2002 Microsoft Corporation. All rights reserved.This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.