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.

By John John is a CPA, MBA and has been a Performance Management consultant for over 25 years. He is the founder of ExploringTM1 and highly regarded for his experience combining financial management with corporate planning, reporting and analysis. He lives in Sydney with his wife, two of his three children, their cat, Freckles, a bunch of chooks and some fish. John is a sports nut, who played rugby until he was 40, started playing football at 54 and loves being outdoors.

You might also like

Filtering Data

Filter MDX Function in Planning Analytics

2 min read
| |

Slow MDX Subsets? Best Practice Guide to Maintain Sets in TM1

2 min read