Category Archives: PerformancePoint

End-User Microsoft BI Tools – Clearing up the confusion

Posted on February 27, 2012 by

Given two types of underlying data sources (a data warehouse and a OLAP cube built from the data warehouse) there are many different possible presentation layers (client tools) that serve different user communities with varying usage profiles.  There is a … Continue reading →

Posted in Excel, PerformancePoint, Power View/Project Crescent, PowerPivot, ProClarity, Report Builder, SQLServerPedia Syndication, SSRS, White Paper | Leave a comment

Performance tips for SSAS

Posted on October 17, 2011 by

Over the past few years I have developed a list of ways to improve performance in SSAS and in two of the tools that use it: ProClarity and PerformancePoint.  Below are those performance tips along with other important items to be … Continue reading →

Posted in PerformancePoint, ProClarity, SQLServerPedia Syndication, SSAS | 2 Comments

Context-sensitive menus in PerformancePoint

Posted on September 21, 2011 by

Frequently I see a bit of confusion from business users when using an analytic grid on a dashboard in PerformancePoint.  The confusion comes when you right-click on the analytic grid and see a context-sensitive menu.  When you right-click on any … Continue reading →

Posted in PerformancePoint, SQLServerPedia Syndication | Leave a comment

Tracking down KPI error in PerformancePoint

Posted on August 22, 2011 by

On a few occasions, I have opened up my PerformancePoint scorecard on SharePoint to see an error staring at me: So two of my KPI’s, which have been working fine for months, suddenly don’t work.  Follow along and I will … Continue reading →

Posted in KPI, PerformancePoint, SQLServerPedia Syndication | Leave a comment

What’s coming in SP1 for PerformancePoint

Posted on June 14, 2011 by

Check out What’s New in PerformancePoint Services and SP1? to see a list of the major features and updates included in SP1 for PPS.  Note that SP1 is an Office 2010 service pack, and it’s due at the end of this month.  … Continue reading →

Posted in PerformancePoint, SQLServerPedia Syndication | Leave a comment

PerformancePoint 2010 source control

Posted on June 3, 2011 by

While there is no way to use a source control system such as Team Foundation Server (TFS) or Subversion with PerformancePoint 2010, all is not lost.  You can use the version control in SharePoint as your source control since all PerformancePoint … Continue reading →

Posted in PerformancePoint, SharePoint, SQLServerPedia Syndication | Leave a comment

PerformancePoint wish list – change a datasource

Posted on June 1, 2011 by

One item on my PerformancePoint wish list is the ability to change a datasource for an Analytic Chart/Grid.  There is no way to do this.  Instead you must create a new datasource and build the Analytic Charts/Grids from scratch using the new … Continue reading →

Posted in PerformancePoint, SQLServerPedia Syndication | Leave a comment