Category Archives: MDX

The Pick List – How to Create and Use Picklists in TM1

Picklists in TM1 are a great way for you to ensure that users only “enter” (or in this case select) a value from a standard list of options. For example, you might want a user to enter a three character month like Jan, Feb, Mar etc. You could design your cube to have a text element and then ask users to enter periods in that format. This will work perfectly … Continue Reading

This entry was posted in Attributes, Cubes, Dimensions, MDX and tagged Picklists, TM1. Bookmark the permalink. | Tagged Picklists, TM1 | Leave a comment

Creating Dynamic Subsets in TM1

Have you ever needed to have a TM1 subset that automatically includes all elements? What, I hear you say, doesn’t that always occur? Well no.  You can have static subsets (which is the default), or you can make dynamic subsets using MDX. And it’s easy! How to Create Dynamic Subsets using MDX Open Subset editor Turn on View, Expression Window Tools, Record Expression Manipulate elements to what you want Tools, … Continue Reading

This entry was posted in Dimensions, MDX. Bookmark the permalink. | Leave a comment

What is a Set in a TM1 MDX Expression

A <set> in an MDX expression in TM1 refers to a group of elements.  Usually in TM1, this would be a subset in a dimension, although note that not all subsets are created by MDX.  So when using <set> in an MDX statement, usually you will refer to a subset of a dimension.

This entry was posted in MDX. Bookmark the permalink. | Leave a comment

MDX in TM1 – a Basic Introduction

MDX in TM1 leverages of the standard MDX language (note leverages off, not uses). It is an industry standard query language for multi dimensional analysis. TM1 does not support the entire language and also adds on TM1 relevant features as well. Keeping Dimension Subsets Up to Date In a dimension, a great way to keep a subset up to date is to use MDX.  To do this enable the view of the … Continue Reading

This entry was posted in MDX. Bookmark the permalink. | Leave a comment