Members, Cells, Tuples, Sets

Members

A Member is a specific value in a dimensional hierarchy. In the below Geography hierarchy, Asia, Europe, North America, Canada, Mexico, United States, Boston, Chicago, Los Angeles and New York are all members, of the Geography hierachy.

Hierarchy Structure	Hierarchy with Members
Continent     Country     City	Asia Europe North America Canada Mexico United States Boston Chicago Las Angeles New York ... South America

Cells

A Cell is the specific intersection of a measures or measures and the members of a heirarchy. The highlighted block below - "600" is an example of a cell. The other values (1,000,$5000,$3000) are also each separate cells.

		Sales	Profit
Ohio	Cleveland	1,000	$5000
	Columbus	600	$3000

Tuples

A Tuple is a specific member from each dimension in the cube. A Tuple uniquely identifies a cell or a section of the OLAP cube. When specifying a tuple in MDX, each member does not have to be explicitly mentioned. If dimension members are not specified, then the default member of that dimension will be used (Most often the 'ALL' member will be used).

example 1:
([Geography].[Continent].[Europe])

example 2:
([Date].[Calendar].[2008].[Feb 2008])

example 3:
([Geography].[Continent].[Europe],[Date].[Calendar].[2008].[Feb 2008])

Sets

A Set is a collection of Tuples.