Geeks With Blogs
James Rogers BI from the trenches... October 2007 Entries
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: