How to create use Dynamic Row Members with Page Filters
When the Microsoft PerformancePoint Scorecard group released Update Rollup 3, you will have the ability to have dynamic row members using an MDX Expression. You can also use a Page Filter and allow the end user to slice the Row Members and filter them out. Using the following MDX Expression, you can do same!
<$[Personnel].[Hierarcy]$> is the value you need to notice, that format has a matching Page Filter. So when the end-user slices the Page Filter, the Personnel members will be shown where the Measure is not Null. That will show only row members where they have values.
Email me with questions
Patrick