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.
Filter by Status - Tm1 Scorecarding
-
- 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
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.
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
-
- 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
Hi Declan.
Thanks a lot.
Will look into it.
Much appreciated.
Thanks a lot.
Will look into it.
Much appreciated.
-
- 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
Hi Declan.
This works fine.
Thanks again.
This works fine.
Thanks again.