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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
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 →