MDX - What is Set?

by Kiran 14. March 2011 11:49

A Set is a collection of tuples which defined using same dimensions, both type and number. Set is enclosed within curly braces { and }. following is the example of set based on Adventure Works sample cube.

Tuples ([Customer].[Country].[India]) and ([Customer].[Country].[France]) are from exact same dimension. So collection of such tuples are valid Set.

{ ([Customer].[Country].[India]), ([Customer].[Country].[France]) }

A set can contain zero, one more tuples. A Zero Tuple Set is called as empty set. An enpty set is represented as

{ }

Tags: , ,

SQL Server Analysis Services

Category

Recent Posts

Tag cloud