Rule Terminology

Dimension - Organizes measures of information in the cube.

Hierarchy - A set of members and levels within a dimension. A dimension can contain multiple hierarchies.

Level - Represents the position of a node in the dimensional hierarchy.

Member - Hierarchy elements are referred to as Members.

Tuple - An ordered collection of one or more members from different dimensions. For example, a single member from an account with a member key of 200.

([Account].&[200])

A tuple is also a single member from two dimensions being account with a member key of 200 and department with a member key of 19.

([Account].&[200],[Department].&[19])
([Account].&[200],[Department].&[19],[Company].&[1])

When multiple dimensions are part of a tuple (as in the above examples) each dimension member should be separated by a comma and all the members should be enclosed in parenthesis.

Set - Multiple members from the same dimension or a group of multiple cells. For example, current year 2017 and 2018 are both from the Time dimension. They are surround by curly braces (shown in the example below), which is required for sets.

{[CY 2017].[CY 2018]}

In the example below there are multiple tuples in a set. There is one set with curly braces at beginning and end. The tuples include account and department (enclosed in parenthesis). Two cells will be returned; one for account and one for department.

{([Account].&[200],[Department].&[19]),([Account].&[210],[Department].&[19]), 
([Account].&[210],[Department].&[20]), ([Account].&[220],[Department].&[20])}
([Account].&[210],[Department].&[20]), ([Account].&[220],[Department].&[20])}