Filter MDX Function in Planning Analytics

Filtering Data

Definition The TM1 MDX function FILTER in IBM Planning Analytics is utilised to selectively retrieve data from multidimensional cubes based on specified criteria. In conjunction with other MDX functions like TM1FILTERBYLEVEL or DESCENDANTS, users can dynamically filter data based on levels, hierarchies, or specific dimensions. Syntax of Filter MDX The basic syntax for Filter function…

Read More

How to use TM1 Attributes in Report Studio

TM1 best practice guides recommend using codes for creating hierarchies and using names as aliases. With TM1 it is also very common to work with various other attributes. But when you create a package with framework manager you can choose what alias you want to show in reports. So you normally use the name as…

Read More