Dynamic Row Members in Business Scorecard Manager 2005

There comes a time you wish you could change a page filter on a scorecard to show all the sales reps for Arizona within BSM, but you just didn’t think it was supported…

Well, in Update Rollup 3, you now can do it!!   Here what you have to do.

My first example will be countries that show dynamically as a ROW MEMBER.

1.  Edit your Scorecard View
2.  Click on the ROW MEMBERS property
3.  ADD and MDX Expression

This MDX Expression will give you all members for that dimension within that Hierarchy.  This is a good solution when you have a dimension that changes and you do not want to go into BSM and check/uncheck members within a dimension.  What a pain.

Now you have a dynamic scorecard!!  WooHOO!!!

This next example will be Allow you to pick a Country on the Page Filter and show the Children of that Country that will show dynamically as a ROW MEMBER.

1.  Edit your Scorecard View
2.  Click on the ROW MEMBERS property
3.  ADD and MDX Expression, note the <$[dimension].[hierarchy]$> part, that is the page filter you are going to add below.

This MDX Expression will give you all members for that dimension within that Hierarchy.  This is a good solution when you have a dimension that changes and you do not want to go into BSM and check/uncheck members within a dimension.  What a pain.

4.  Add the following page filter.  I added a default slice for the sample.  But if you change the slice in the scorecard, it will render new row members.

5. And here is the scorecard!  Pretty cool.

Special Note:  You will need to set your data source cache to zero.  Since this is a dynamic scorecard, it will not work with cached data.  So think about the performance impact if any within your project.

Well, that is a quick example.  Email me with questions.

Regards

Patrick

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s