Filter by Status - Tm1 Scorecarding

Post Reply
DYNA
Posts: 22
Joined: Mon Jul 29, 2019 10:09 am
OLAP Product: PLANNING ANALYTICS (TM1)
Version: 2.0.6
Excel Version: Excel for office 365
Location: SOUTH AFRICA

Filter by Status - Tm1 Scorecarding

Post by DYNA »

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.
declanr
MVP
Posts: 1828
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Filter by Status - Tm1 Scorecarding

Post by declanr »

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.
Declan Rodger
DYNA
Posts: 22
Joined: Mon Jul 29, 2019 10:09 am
OLAP Product: PLANNING ANALYTICS (TM1)
Version: 2.0.6
Excel Version: Excel for office 365
Location: SOUTH AFRICA

Re: Filter by Status - Tm1 Scorecarding

Post by DYNA »

Hi Declan.

Thanks a lot.

Will look into it.

Much appreciated.
DYNA
Posts: 22
Joined: Mon Jul 29, 2019 10:09 am
OLAP Product: PLANNING ANALYTICS (TM1)
Version: 2.0.6
Excel Version: Excel for office 365
Location: SOUTH AFRICA

Re: Filter by Status - Tm1 Scorecarding

Post by DYNA »

Hi Declan.

This works fine.

Thanks again.
Post Reply