Search code examples
sqlssasmdx

Difference between tuple and set in mdx

What is the difference between tuple and set in MDX. How we can distinguish both and when we are using them.

Solution

  • A tuple is a single hierarchy member taken from all the dimensions. Suppose Time.[2nd half] is a tuple of time dimension. At the same way we can have multiple tuples and we represent them in '(',')' brackets. Eg: 

    (Time.[2nd half], Color.Dark.Red).

    This is nothing but the mathematical intersection of nodes. we can represent the nodes in maths as (2,1) in the same way above expression will work.

    Now coming to sets it is nothing but the composition of tuples. set contains one or more tuples it may zero also. we represent them in { , } braces. Eg: 

    { (Time.[1st half], Color.Dark.Red), (Time.[2nd half], Color.Dark.Blue) }