TM1 Forum

Hi.

Is there anyway to filter by the Status for Tm1 Scorecarding?

For example, on PAW, is there anyway that I can select the excellent status and have it display only the records with an excellent status?

This must work dynamically like a normal filter.

Thank you.

I must admit that I haven't looked at or used scorecards for quite a long time.
However, if memory serves the "status" is just a measure in your cube - so you could have MDX subsets that filter your driver dimension for each possible status (e.g. 1 subset for Excellent, 1 for Poor etc.) then just choose that subset.

Assuming that works you can also drag the subset selection above your scorecard widget to have a selection widget.

Hi Declan.

Thanks a lot.

Will look into it.

Much appreciated.

Hi Declan.

This works fine.

Thanks again.