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 » SQL Analysis Services 2005   (RSS)

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

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

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). (sample code below) THE CODE References To be able to override an EPM 2007 Event Handler and do Read More...
Posted Monday, August 06, 2007 9:46 PM by chrisfie | 0 Comments
Attachment(s): EPM2007 - Customizing AS Cubes Using AMO.zip

Configuring Project Server With Excel Services To Leverage New Reporting Capabilities

Ever wondered how to produce nice looking reports based on Project Server OLAP data (cubes) using Excel 2007 and Excel Services without using the Office Web Component (OWC). The document below explains the steps to follow to integrate Project Server 2007 Read More...
Posted Tuesday, May 15, 2007 4:04 PM by chrisfie | 1 Comments
Attachment(s): Project Server 2007 & Excel Services.pdf

Newly published content for Office Project Server 2007

You should probably bookmark this url: Newly published content for Office Project Server 2007 and check it on a regular basis for updated documentation on the EPM 2007 platform. For instance this month a detail guide on configuring OLAP for EPM 2007 using Read More...
Posted Thursday, April 26, 2007 5:02 PM by chrisfie | 0 Comments

How to update Analysis Views (OLAP) after an EPM 2003 to EPM 2007 migration?

After migrating your database from Project Server 2003 to Project Server 2007, or after migrating from one environment to another (Production to Development for instance), a quick and easy way to update the Data Analysis Views is to issue the following Read More...
Posted Monday, April 23, 2007 1:59 PM by chrisfie | 0 Comments

Analysis Services 2005 (OLAP) Permission for Project Server 2007

Common questions and answers on AS 2K5 permissions for EPM 2007 (thank you David & Steven): Getting Cube to Build 1. Which application account is responsible for building the cube? Is this the SSP account? The SharePoint Timer Service account? SSP Read More...
Posted Thursday, March 01, 2007 6:44 PM by chrisfie | 3 Comments

Why consider a Project Server 2007 deployment with Microsoft Office SharePoint Server (MOSS)?

By default Project Server 2007 gets deployed on top of WSS V3. I've listed below reasons why one should consider deploying Project Server 2007 with Microsoft Office SharePoint Server. Three State Workflow for Proposals , see Brian post Project Server, Read More...
Posted Wednesday, February 28, 2007 10:05 AM by chrisfie | 0 Comments

Common mistakes when configuring the Cubes Building Service (CBS) with SQL Server Analysis Services 2005

Prior to troubleshooting your Analysis Services 2005 configuration to "build" your Project Server Cubes, I'll assume you have read the following KB article: 921116 During the CBS you get the following error: "Error: ActiveX component can't create object" Read More...
Posted Wednesday, January 24, 2007 10:17 AM by chrisfie | 0 Comments

Configuring a SQL 2005 Analysis Repository for DSO9 instead of an Access MDB

The standard procedure to configure ( KB 921116 ) the Cube Building Services (Analysis Services 2005) for Project Server is to copy the Msmdrep.mdb file on a network share. ¾ Get a backup of a SQL 2000 AS Repository database (you can use the migration Read More...
Posted Thursday, December 14, 2006 4:43 PM by chrisfie | 2 Comments
Attachment(s): AS2000_Repository_BAK.zip

Configuring Project Server 2007 with SQL Server Analysis Services 2005

When you use SQL Server 2005 Analysis Services (please note you need to apply SP1), you'll have to follow the procedure described in this KB to configure the "cube refresh": http://support.microsoft.com/default.aspx/kb/921116/en-us Read More...
Posted Saturday, December 09, 2006 1:11 PM by chrisfie | 0 Comments
 
Page view tracker