Wen He

Skills

• Config SQL Server Analysis Repository
• Config Alternate Authentication
• Config reporting cube settings

Resources

• http://blogs.msdn.com/project_programmability
• Developer bookmarks
• Reporting Services
• CodePlex.com/project
• CodePlex/EPMIP
• /EPMBDC
• codeplex.com/EPMInfopath

Bookmarks (from MSDN)

• Project
• SharePoint
• VBA
• PSI Extension
• Reporting
• Reporting Services
• Analysis Services
• Excel Services
• Windows Workflow Foundation
• Tools
• Line of Business Integration
• Business Data Catalog
• InfoPath

Developer Bookmarks

Subject	Description	Link
Office	Microsoft Office Interactive Developer Map   The Microsoft Office Interactive Developer Map is a Windows Presentation Foundation (WPF) application that helps developers visualize the different programs, servers, services, and tools that will help them build solutions. It allows them to drill down to each product and technology and learn about new features, objects, Web services, namespaces, and schemas required to extend Microsoft Office and build custom Office Business Applications (OBAs).	http://msdn.microsoft.com/en-us/office/bb497969.aspx
Project (General)	What's new in Office Project 2007: This article examines what is new in Microsoft Office Project Server 2007, Project Web Access 2007, and Microsoft Office Project Professional 2007.	http://go.microsoft.com/fwlink/?LinkID=93713
	Project Developer Portal Welcome to the Microsoft Office Project and Microsoft Office Project Server developers' home on MSDN. In this section, you will find summaries and links to information about planning, developing, and deploying Project– and Project Sever-based solutions.	http://msdn.microsoft.com/en-us/office/aa905469.aspx
	Welcome to the Microsoft Office Project 2007 SDK Welcome to the Microsoft Office Project 2007 Software Development Kit (SDK). The SDK contains documentation, code samples, how-to articles, and programming references to help customize and integrate the Office Project 2007 clients and Microsoft Office Project Server 2007 with a wide variety of other desktop and business applications for enterprise project management.	http://msdn.microsoft.com/en-us/library/ms512767.aspx http://www.microsoft.com/downloads/details.aspx?FamilyId=2672F6F9-7028-4B30-99A2-18CB1EED1ABE&displaylang=en (download)
	Project Server 2007: Getting Started with a New Platform for Developers  Explore Microsoft Office Project Server 2007 functionality that uses a completely new platform built on Microsoft .NET Framework 3.0 and Windows SharePoint Services 3.0. Use the Project Server Interface (PSI) and Project Server events to extend and integrate Project Server with other applications. Extend Project Web Access, now a Windows SharePoint Services 3.0 site. Learn about the new Reporting database and Cube Build Service.	http://msdn.microsoft.com/en-us/library/bb456485.aspx
	Managing Security in Project Server 2007: These articles describe how to manage Project Web Access users, groups, categories, templates, and Active directory synchronization.	http://technet.microsoft.com/en-us/library/cc197571.aspx
	Understanding and Using the Queuing system in Office Project Server 2007 (Downloadable book): Covers instructions for understanding and using the Queuing system in Office Project Server 2007.	http://go.microsoft.com/fwlink/?LinkId=93744
SharePoint	SharePoint Server 2007 SDK: Software Development Kit   The Microsoft Office SharePoint Server 2007 SDK contains conceptual overviews, “How Do I…?” programming tasks, developer tools, code samples, references, and an Enterprise Content Management (ECM) starter kit to guide you in developing solutions based on Microsoft Office SharePoint Server 2007.	http://www.microsoft.com/downloads/details.aspx?familyid=6D94E307-67D9-41AC-B2D6-0074D6286FA9&displaylang=en (download)
	Windows SharePoint Services 3.0: Software Development Kit (SDK)   The Windows SharePoint Services 3.0 software development kit (SDK) contains conceptual overviews, programming tasks, samples, and references to guide you in developing solutions based on Microsoft Windows SharePoint Services 3.0.	http://www.microsoft.com/downloads/details.aspx?familyid=05E0DD12-8394-402B-8936-A07FE8AFAFFD&displaylang=en  (download)
	SharePoint Learning Resources: Learn more about Office SharePoint Server 2007 and related technologies to take advantage of the full enterprise capabilities. This site includes highlighted learning resources for developers and IT professionals.	http://sharepoint.microsoft.com/readiness/pages/search.aspx
	The SharePoint Developer Introduction for .NET Developers	http://www.microsoft.com/click/SharePointDeveloper/ http://MSSharePointDeveloper.com
	Best Practices: Using Disposable Windows SharePoint Services Objects   Learn the appropriate ways to write your code when using Microsoft Windows SharePoint Services objects so that you can avoid retaining the objects in memory with the Microsoft .NET Framework.	http://msdn.microsoft.com/en-us/library/aa973248.aspx
	Best Practices: Common Coding Issues When Using the SharePoint Object Model   Learn about common issues encountered by developers who write custom code by using the SharePoint object model.	http://msdn.microsoft.com/en-us/library/bb687949.aspx
	SharePoint Developers Webcast   In this 10 part series, you will receive practical technical information from Robert Bogue and Andrew Connell, both SharePoint MVPs, covering 10 fundamental developer topics on SharePoint via Live Meeting webcast.	http://blogs.msdn.com/chrisfie/archive/2008/05/21/sharepoint-developers-webcast.aspx
Project Desktop	Test Framework   Controller/client test framework can be used to test any assembly or .exe with and object model (any MS Office app).	http://www.codeplex.com/TestFramework
	Sample COM Add-in code for Project Professional 2007	http://blogs.msdn.com/chrisfie/archive/2007/08/03/sample-com-add-in-code-for-project-professional-2007.aspx
	Importing Project 2007 Tasks from Excel Using a Managed Code Add-In   Learn how to develop and deploy a managed code add-in for Microsoft Office Project 2007 that imports task data from Microsoft Office Excel, using Microsoft Visual Studio 2008 with Visual Studio Tools for Office.	http://msdn.microsoft.com/en-us/library/bb738433.aspx
¡ Visual Basic for Applications (VBA)	Visual Basic for Applications	http://msdn.microsoft.com/en-us/isv/bb190538.aspx
	Converting Code from VBA to Visual Basic .NET	http://msdn.microsoft.com/en-us/library/aa192490(office.11).aspx
	Migrating a VBA Solution to a Visual Studio Tools for Office Add-In	http://msdn.microsoft.com/en-us/library/aa830702.aspx
	Project Object Model	http://msdn.microsoft.com/en-us/library/bb179353.aspx
¡ Visual Studio Tools for Office (VSTO)	Office Development with Visual Studio Developer Portal	http://msdn.microsoft.com/en-us/office/aa905533.aspx
Timesheet and Statusing	Timesheeting and Statusing Data Flow Diagram   Please find attached a Visio 2007 diagram that shows the standard data flow for time tracking and reporting progress in EPM 2007. Might be useful if you are doing customization using the Tied-Mode solution starter released last week on CodePlex.	http://blogs.msdn.com/chrisfie/archive/2007/11/20/timesheeting-and-statusing-data-flow-diagram.aspx
	Project Server 2007 Timesheet data population tool  The Project Server 2007 Timesheet Data Population Tool enables you to simulate timesheet entries in your farm. This tool can help you perform scalability studies of your PS architecture and validate the sizing of an existing architecture (by measuring timesheet queue throughput for instance). This tool can also be used to test timesheet customization, for instance the Timesheet Tied-mode code sample on http://www.codeplex.com/EPMTSST. This powerful tool should not be run a production environment.	http://www.codeplex.com/EPMTSdatapop
	EPM Timesheet & Statusing Customization Samples Code samples that demonstrate how EPM (Project Server) 2007 Timesheet and Statusing functionalities could be customized using custom event handlers and Project Server Interface calls. These samples leverage the Timesheeting and Statusing API documented in the EPM 2007 SDK	http://www.codeplex.com/EPMTSST
	Project Server 2007 Timesheet Tied-Mode Service and Event Handler  This project is used with Microsoft Project Server 2007. It consists of an NT service, an event handler, a test app and installer. The event handler is fired when a tiemsheet is saved. The handler saves the timesheet info in a SQL table. The NT service (TSAutoStatus) polls the table for work from the event handler. It imports and submits the timesheet. This work is based upon EPM Timesheet tied-mode work done by Christophe Fiessinger (http://blogs.msdn.com/chrisfie).	http://www.codeplex.com/AutoStatusService
	Figuring out the ChangeXML format when using the 'UpdateStatus' method	http://blogs.msdn.com/chrisfie/archive/2007/10/31/figuring-out-the-changexml-format-when-using-the-updatestatus-method.aspx
PSI Extension	Scenarios for PSI Extension   following reasons why one might consider such customization	http://blogs.msdn.com/chrisfie/archive/2007/07/31/scenarios-for-psi-extension.aspx
	Walkthrough: Creating a PSI Extension  The Project Server Interface (PSI) for Microsoft Office Project Server 2007 can be extended with custom Web services. PSI extensions tightly integrate with Project Server, can call other PSI methods, and can use the same security infrastructure that the rest of the PSI uses.	http://msdn2.microsoft.com/en-us/library/bb428837.aspx
	Lessons Learned from writing a PSI Extension	http://blogs.msdn.com/chrisfie/archive/2007/08/02/lessons-learned-from-writing-a-psi-extension.aspx
Reporting	New SQL Reporting Services Sample Reports for Project Server	http://blogs.msdn.com/chrisfie/archive/2008/04/10/new-sql-reporting-services-sample-reports-for-project-server.aspx
	Project Server Extended Report Pack from Project Conference	http://blogs.msdn.com/chrisfie/archive/2007/10/30/project-server-extended-report-pack-from-project-conference.aspx
	Project Server 2007 Sample Databases   Project Server 2007 sample databases.	http://code.msdn.microsoft.com/PS2007SampleDB
	How to extract and view Timesheet Audit Data?	http://blogs.msdn.com/chrisfie/archive/2007/10/10/how-to-extract-and-view-timesheet-audit-data.aspx
	Controlling the project workspaces list	http://blogs.msdn.com/chrisfie/archive/2007/10/03/controlling-the-project-workspaces-list.aspx
	Getting at the Task Time Phased Data	http://blogs.msdn.com/project_programmability/archive/2007/05/24/getting-at-the-task-time-phased-data.aspx
	Reporting Database Extensions: Local Custom Fields Custom Code  This custom solution builds on the Project Server 2007 server-side event model to cache a report-friendly copy of Project Local Custom Fields in the Reporting database.	http://blogs.msdn.com/project_programmability/archive/2008/01/03/reporting-database-extensions-local-custom-fields-custom-code.aspx
	Scalable Issues & Risks Report	http://blogs.msdn.com/project_programmability/archive/2007/09/28/scalable-issues-risks-report.aspx
	How to create a Milestone Report	http://blogs.msdn.com/chrisfie/archive/2008/03/11/how-to-create-a-milestone-report.aspx
	How to track EPM Resource field changes in your Reporting Database	http://blogs.msdn.com/chrisfie/archive/2007/10/26/how-to-track-epm-resource-field-changes-in-your-reporting-database.aspx
¡ SQL Server Reporting Services (SSRS)	SQL Server 2005 – Reporting Services   SQL Server 2005 Reporting Services is a new server-based reporting platform that you can use to create and manage tabular, matrix, graphical, and free-form reports that contain data from relational and multidimensional data sources. The reports that you create can be viewed and managed over a Web-based connection.	http://technet.microsoft.com/en-us/sqlserver/bb331776.aspx
	Implementing a Security Extension   Microsoft Windows Authentication is the primary system for securing reports in Microsoft SQL Server 2005 Reporting Services. In certain cases, however, you may need to extend the Reporting Services security system to accommodate custom security in your enterprise. You can do this using the development platform provided by the Reporting Services API. This section will present an overview of security extensions in Reporting Services.	http://msdn.microsoft.com/en-us/library/ms155029.aspx
	Customizing Analysis Services Cube Using Analysis Management Objects (AMO)   This post describes the steps required to perform SQL Analysis Services 2005 Project Server 2007 Cube customization using Analysis Management Objects (AMO).	http://blogs.msdn.com/chrisfie/archive/2007/08/06/customizing-analysis-services-cube-using-analysis-management-objects-amo.aspx
¡ SQL Server Analysis Services (SSAS)	Analysis Management Objects (AMO)	http://msdn.microsoft.com/en-us/library/ms124924.aspx
	Persisting SSAS OLAP Roles In Project Server 2007 During the standard Cube Building process in Project Server 2007, any manually added OLAP Roles in an OLAP database are deleted. The Cube building creates a default Role ProjectServerViewOlapDataRole that automatically adds all the Project Server users to this Role. This customization saves the configuration of the existing OLAP Roles (except for ProjectServerViewOlapDataRole) in a text file, before they are deleted but the standard cube building process, using the OnCubeBuilding event. The saved configuration of the OLAP Roles is then restored using the following event OnCubeProcessed.	http://www.codeplex.com/epmssas
	Customizing Analysis Services Cube Using Analysis Management Objects (AMO)	http://blogs.msdn.com/chrisfie/archive/2007/08/06/customizing-analysis-services-cube-using-analysis-management-objects-amo.aspx
¡ Excel Services