Author Archives: ddarden

Troubleshooting Writeable Regions in PerformancePoint Plan

Only certain cells are considered “writeable” in a PPS Plan Excel form. A writeable region is a region where the user can enter data. Here is a checklist of reasons why a region that you expect to be writeable is … Continue reading

Posted in Uncategorized | Comments Off on Troubleshooting Writeable Regions in PerformancePoint Plan

Repeated Dimension Names in PerformancePoint Server Monitor & Analyze

A colleague came to me recently with a problem.  She was implementing a Dashboard in PPS M&A, and she was seeing some unexpected dimension names.  The behavior was specifically affecting her when she was creating a report using an Analytic … Continue reading

Posted in Uncategorized | Comments Off on Repeated Dimension Names in PerformancePoint Server Monitor & Analyze

Testing and Tuning an Internet Facing PerformancePoint M&A Dashboard

I’ve spent the past 15 months, off and on, working as the technical lead on a performance management project using PerformancePoint Server.  The project was to create a SharePoint Portal where users could view the performance of a school system.  … Continue reading

Posted in Uncategorized | Comments Off on Testing and Tuning an Internet Facing PerformancePoint M&A Dashboard

How to implement cascading parameters in a SQL Services Reporting Services MDX Report

Background Last week, I needed to prototype a report against an Analysis Services 2005 cube for a client.  The report wasn’t too complicated… I just had the requirement to allow a user to drill down a hierarchy by selecting a … Continue reading

Posted in Uncategorized | Tagged , , | Comments Off on How to implement cascading parameters in a SQL Services Reporting Services MDX Report

MDX Filters in PPS Monitor

I had a question on how to implement MDX Filters in PerformancePoint Monitor awhile back.  Nick Barclay  provided an answer here. Some samples Nick provided were: 1: [Time].[Fiscal Year].Children and 1: DESCENDANTS( 2: [Geography].[Geography].[All Geographies] 3: ,[Geography].[Geography].[Country] 4: ,SELF_AND_BEFORE) Depending … Continue reading

Posted in Uncategorized | Tagged , , | Comments Off on MDX Filters in PPS Monitor

Creating a Scorecard Transform in PerformancePoint Server Monitor

Overview I’ve spent a couple of days doing some prototyping around PerformancePoint Monitor… there have been a few things that I’ve wanted to accomplish, so when the PerformancePoint Monitoring SDK was released, it seemed like the way to do it.  … Continue reading

Posted in Uncategorized | Comments Off on Creating a Scorecard Transform in PerformancePoint Server Monitor