Hi all,
In TM1, am i able to filter by a measure?
For example, i have a "string" measure, with "Status" values such as "Approved" and "Pending Approval". And i want to filter the cube to show only records that are "Approved".
Another example, I have a "number" measure such as "variance". And i want to filter the cube to show only records where the "variance" value is more than 0.1 (10%).
Thanks.
Melvin
Filter by a measure
-
melvinleng
- Posts: 13
- Joined: Mon Jul 11, 2011 3:07 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007
-
lotsaram
- MVP
- Posts: 3701
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Filter by a measure
Simple answer is yes this dan be done with MDX.
-
melvinleng
- Posts: 13
- Joined: Mon Jul 11, 2011 3:07 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007
Re: Filter by a measure
Hi,
Would you be able to explain more on how to use and where to apply the MDX? Thanks.
What i mean is that the user views the data, either in a cube view on the web, or excel attachment on the web, and would like to apply a filter to filter the values that is displayed, by selecting some option or button and entering some parameters.
Would you be able to explain more on how to use and where to apply the MDX? Thanks.
What i mean is that the user views the data, either in a cube view on the web, or excel attachment on the web, and would like to apply a filter to filter the values that is displayed, by selecting some option or button and entering some parameters.