Category Archives: PerformancePoint

PerformancePoint: Show Details greyed out

In PerformancePoint, when using a analytic grid or chart or a scorecard, if you are not able to use the “Show Details” option (a drillthrough action) because it is grayed out, one or more of the following could be the … Continue reading

Posted in PerformancePoint, SQLServerPedia Syndication | Leave a comment

Microsoft BI tools: How they use data sources

A quick list of how each of these Microsoft BI tools handles the two data sources “SQL Server” (relational-based) and “Analysis Services” (cubed-based, which can be the multidimensional model or the tabular model).  Note that any reporting tool that supports the … Continue reading

Posted in Excel, PerformancePoint, Power Pivot, Power View/Project Crescent, Report Builder, SQLServerPedia Syndication, SSRS | 1 Comment

Using PerformancePoint against tabular data

PerformancePoint (PPS) is typically used against multidimensional data sources (i.e. Analysis Services), but it does have the ability, albeit limited, to work against tabular data sources such as SQL Server tables, SharePoint Lists, Excel Services, Import From Excel Workbooks, and even PowerPivot (with … Continue reading

Posted in PerformancePoint, SQLServerPedia Syndication | 2 Comments

PerformancePoint 2013 and SharePoint 2013

PerformancePoint is an important BI Tool in the Microsoft world and it will continue to be Microsoft’s solution for creating interactive, context-driven dashboards with balanced scorecards, key performance indicators, analytic reports, and filters.  There is no doubt it is an integral part of … Continue reading

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

End-User Microsoft BI Tools – Clearing up the confusion

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 Pivot, Power View/Project Crescent, ProClarity, Report Builder, SQLServerPedia Syndication, SSRS, White Paper | 2 Comments

Performance tips for SSAS

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

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

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

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

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