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