EPM, Enterprise Project Management, Project Server, Project Portfolio Server, SharePoint Services, SharePoint Server
Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Reporting   (RSS)

Microsoft PerformancePoint Server 2007 Service Pack 1 (SP1) is ready for download

PerformancePoint Server 2007 is an integrated performance management application that allows customers to monitor, analyze, and plan their business as well as drive alignment, accountability, and actionable insight across the entire organization. PerformancePoint Read More...
Posted Saturday, June 07, 2008 2:49 AM by chrisfie | 0 Comments

How to display Microsoft Project Task’s Notes field in a report

In MS Project you have the ability to add notes to each tasks in a project plan. This data is stored as an Image Data Type in the SQL database called TASK_RTF_NOTES (note that the field TASK_NOTES is a nvarchar of size 255 , thus you’ll only get the first Read More...
Posted Wednesday, June 04, 2008 6:19 AM by chrisfie | 1 Comments
Attachment(s): Report TASK RTF NOTES.zip

Leveraging the published Project Server Reporting Database Schema

A key success to a Project Server deployment are meaningful reports and dashboards for everyone in the organization. Even though PS comes with standard reports; in order to meet your exact business needs you might have to create custom reports using products Read More...
Posted Friday, May 09, 2008 8:26 PM by chrisfie | 0 Comments

How to deploy the Timesheet Compliance Report

I recently posted a series of SQL Server Reporting Services (SSRS) reports that are used in our newly updated EPM demo VPC: New SQL Reporting Services Sample Reports for Project Server . Since a few people asked for a step by step guide to use these reports Read More...
Posted Wednesday, May 07, 2008 10:03 PM by chrisfie | 0 Comments

PerformancePoint Server Virtual Labs

As mentioned in the past PerformancePoint Server 2007 is RTM! , PerformancePoint Server (PPS) could be of great value to EPM deployments. To ramp up on PPS and actually practice in a live environment check the following TechNet hands on labs (free of Read More...
Posted Thursday, May 01, 2008 10:36 PM by chrisfie | 2 Comments

New Excel Services Sample Reports for Project Server

Following this post ( New SQL Reporting Services Sample Reports for Project Server ), please find below the list of Excel Services (samples attached) reports included in the newly released demo VPC. If you want to learn more about Excel Services (requires Read More...
Posted Sunday, April 13, 2008 6:12 PM by chrisfie | 2 Comments
Attachment(s): EPM2007 VPC v2- Excel Reports.zip

Persist SQL Server Analysis Services Roles settings Solution Starter on CodePlex

A new solution starter that demonstrates how to persist SQL Server Analysis Services (SSAS) Roles settings in the Project Server OLAP database was released today on CodePlex . For instance you might require to create specific Roles in your OLAP database Read More...
Posted Thursday, April 10, 2008 11:47 PM by chrisfie | 1 Comments

New SQL Reporting Services Sample Reports for Project Server

We have released last week an updated version of our EPM 2007 demo VPC. Please find below the SQL Server Reporting Services (SSRS) reports used in that VPC. All these SSRS reports are using the Project Server 2007 Reporting database as a data source. Read More...
Posted Thursday, April 10, 2008 7:15 PM by chrisfie | 9 Comments
Attachment(s): EPM2007 VPC V2- SSRS Reports.zip

How to create a Milestone Report

While delivering Project Server training in Beijing, a customer asked me to produce a report that displayed Milestones dates by Projects. The assumption is that all projects are using the same project template and thus there is a specific naming convention Read More...
Posted Tuesday, March 11, 2008 8:04 AM by chrisfie | 1 Comments

Project Server Extended Report Pack from Project Conference

Following my presentation yesterday on reporting at the Project Conference in Seattle, please find below the "Extended" EPM report pack I demoed (leveraging SQL Server Reporting Services). Reports added are: Deliverables and Dependencies Issues and Risks Read More...
Posted Tuesday, October 30, 2007 4:40 PM by chrisfie | 0 Comments
Attachment(s): Microsoft Project 2007 Report Pack Extended Project Conference.zip

How to track EPM Resource field changes in your Reporting Database

Leveraging the EPM 2007 Eventing service as well as the Reporting database here is a way of tracking all changes made to a Resource's fields. A common request I heard from customers is the ability to track when a Resource changes from one node to another Read More...
Posted Friday, October 26, 2007 12:46 AM by chrisfie | 0 Comments
Attachment(s): ResourceFieldTracking.zip

Using a PSI Data Source in SQL Server Reporting Services

SQL Server Reporting Services 2005 (SSRS) has the ability to query data from XML data sources and thus from Web Services, for more information on this subject refer to Reporting Services: Using XML and Web Service Data Sources . Since EPM 2007 is architected Read More...
Posted Wednesday, October 24, 2007 1:15 AM by chrisfie | 1 Comments

How to extract and view Timesheet Audit Data?

In EPM 2007 you have the ability to audit all timesheet transactions using the following flag: Server Settings >Time and Task Management > Settings and Defaults > Enable Timesheet Auditing Once audit has been activated, all timesheet changes Read More...
Posted Wednesday, October 10, 2007 7:16 PM by chrisfie | 1 Comments
Attachment(s): Timesheet Audit 2.rdl

Controlling the project workspaces list

By default when provision a Project Web Access site, the home page contains a webbox called “Project Workspaces” which display a list of all project’s WS that have been created. By default there are two ways to display the list of WS: “All Workspaces” Read More...
Posted Wednesday, October 03, 2007 10:41 PM by chrisfie | 3 Comments
Attachment(s): Project WS 1.rdl

PerformancePoint Server 2007 is RTM!

Yes the other PPS (not Project Portfolio Server J ) has just been released. PerformancePoint Server could be a great addition to an EPM deployment if you need dash boarding capabilities for instance. For more information on the product or to download Read More...
Posted Wednesday, September 26, 2007 9:13 PM by chrisfie | 2 Comments
More Posts Next page »
 
Page view tracker