Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » OLAP   (RSS)
Wednesday, May 13, 2009 8:13 PM

SQL Server 2008 R2

Announced today at TechEd: SQL Server 2008 R2 , will be a great enhancement to Project Server deployment from a reporting perspective, why? Check the following preliminary resources (more info here: R2 Benefits by Workload ): Self Service Analysis with
Posted by chrisfie | 0 Comments
Filed under: , ,
Friday, January 30, 2009 2:49 AM

How to Leverage Project Server 2007 with PerformancePoint Server 2007 Monitoring and Analytics?

I am pleased to announce the release of a white paper written by Symmetry Corporation entitled: How to Leverage Project Server 2007 with PerformancePoint Server 2007 Monitoring and Analytics . This white paper provides an overview of the Microsoft PerformancePoint
Posted by chrisfie | 0 Comments
Thursday, September 25, 2008 8:50 PM

Latest resources for Project Server and PerformancePoint Server Integration

The EPM data structures represent two decades worth of investment and refinement in the field of project management. This mission critical line of business application with its predefine and extendable schema can be enhanced and delivered by the Microsoft
Posted by chrisfie | 2 Comments
Thursday, April 10, 2008 11:47 PM

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
Posted by chrisfie | 1 Comments
Friday, February 08, 2008 12:42 AM

New Microsoft Business Intelligence (BI) blog on MSDN

Since it's a recurring need for EPM deployment, BI/Reporting ... you might want to subscribe to that newly created blog to get the latest MS information: http://blogs.msdn.com/bi/ Welcome to THE BI Blog Welcome to what we hope will become the definitive
Posted by chrisfie | 1 Comments
Monday, August 06, 2007 9:46 PM

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
Posted by chrisfie | 0 Comments
Attachment(s): EPM2007 - Customizing AS Cubes Using AMO.zip
Wednesday, June 06, 2007 5:32 PM

Using Multi-Currency in EPM 2007

EPM 2007 handles multi-currencies at the Project level using the following four options (Tools -> Options -> View -> Currency options): ¾ Symbol ¾ Decimal digits ¾ Placement ¾ Currency While this works fine at the project level, there is no out
Posted by chrisfie | 0 Comments
Tuesday, May 15, 2007 4:04 PM

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
Posted by chrisfie | 1 Comments
Attachment(s): Project Server 2007 & Excel Services.pdf
Thursday, April 26, 2007 5:02 PM

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
Posted by chrisfie | 0 Comments
Monday, April 23, 2007 1:59 PM

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
Posted by chrisfie | 0 Comments
Thursday, March 01, 2007 6:44 PM

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
Posted by chrisfie | 3 Comments
Wednesday, January 24, 2007 10:17 AM

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"
Posted by chrisfie | 0 Comments
 
Page view tracker