Performance Point Scorecard: display children of filter selection

I have a scorecard that uses a filter to display values on a scorecard. It is a geographical hierarchy, so when the user selects 'North America', the scorecard shows one line with the North America aggregate.

The customer has asked for an additional level on this. When the user selects 'North America' in the filter, they would like to see the children of north America on the scorecard- that is the KPI calculated for US and Canada, shown on 2 lines.

I -think- I might need to apply a named set here...I tried creating one that looks like

descendants([Locations].[Location Drilldown].currentmember,1,SELF_AND_AFTER)

But when I stick this on the scorecard, I get one line for each level of the location hierarchy- including levels above and below the filter selection.

Am I on the right track? is this possible?

Thanks,

John

Hi John

What you need to do is add a Connection Formula when connecting to the scorecard.

<<UniqueName>>.Children

Then connect that value to the rows.

Thnaks, Mark! I have this working by connecting the filter to the row in the dashboard designer.

One more question, is it posible to also show the selected member in the rows, in addition to the children?

Such as, user selects 'North America' in the filter and the scorecard shows a row for

North America

- United States

- Canada

- Mexico