TM1 Forum

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

Simple answer is yes this dan be done with MDX.

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.