Geeks With Blogs
James Rogers BI from the trenches... PerformancePoint
PerformancePoint Filter Query suggestions
As I have moved forward with PerformancePoint I have made extensive use of queries for filter building. This approach has a couple of distinct advantages over the other options. Allows filters to be dynamic and pick up new data as it becomes available. One good example of this is a date filter. We use it to keep our filters as a dynamic set of n time periods from the current time period back (i.e. lastperiods(52,exists([Date... Date].&[1]).item(0))) It allows ......

Posted On Wednesday, November 4, 2009 1:14 PM

PerformancePoint Dashboard Performance, KPI Properties and Parameter Passing - Issue Found - Solved in SP1
In PerformancePoint 2007 you have the capability to setup custom properties and pass them into dashboard objects. This is especially useful for simplifying dashboards where you are linking scorecard KPIs to report views. Alyson Powell Erwin outlines how to do this in the PerformancePoint MSDN blog: This is very handy. By setting up a custom property that contains measure names for ......

Posted On Tuesday, August 12, 2008 10:45 PM

Filtering PerformancePoint Reports and Scorecards by Dimensions Different Than the Filter
In my earlier post NON EMPTY Filtering on PerformancePoint Scorecard, I mentioned that you may be able filter scorecards and/or reports by dimensions that are not the same as the filter by using a cross join or other MDX querying technique. This is true if the other dimension is in the same cube as the query or member selection used by the filter. Consider the following: Cube: Sales Dimensions: Organizational Hierarchy (lowest level is Site) Site (this contains attributes that only apply to the site) ......

Posted On Tuesday, March 25, 2008 9:09 PM

Performance, Named Sets, Calculated Measures, PerformancePoint and ProClarity
Many legacy Analysis Services (or OLAP Services) implementations use ProClarity as a querying tool and publishing framework. The server infrastructure of ProClarity allows crafty implementers to push much of the customization in KPI’s and additional measures into the “Presentation” layer of the infrastructure. This is easier to manage and change in many cases than creating named sets and calculated members in the cubes as this generally takes a SSAS administrator. With Microsoft purchasing ProClarity ......

Posted On Wednesday, February 13, 2008 10:15 PM

NON EMPTY Filtering on PerformancePoint Scorecard
For those who are familiar with PerformancePoint scorecards and dashboards, you have probably run into a problem where empty dimension values cannot be dynamically filtered on scorecards if you map the dimension to the rows or columns on the scorecard in the dashboard designer. One simple way around this is to use the NONEMPTY MDX function along with an EXISTS function call. Consider the following example: Scorecard: Sales Filters: Org, Time (Site is the lowest level of the Org dimension) Requirement: ......

Posted On Monday, October 8, 2007 2:13 PM

Copyright © James Rogers | Powered by: