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


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s