Set vs Member vs Tuple in MDX

Sep 20, 2015 22:10

select
{
([Dim_Time].[Time Hierarchy].[Year Key].&[2015],
[Measures].[Agg_Count])
,([Dim_Time].[Time Hierarchy].[Month Key].&[201502],
[Measures].[Agg_Count])
} on columns
from
[My_Cube]

A tuple is a way of referring to a single value within a cube. If you think of a cube as a gigantic multidimensional array, a tuple is a co-ordinate to one cell within that array. ….(с)

A set is an ordered list of members, or tuples….. Each item in a set has to be the same type of a thing: for a set of members, each member has to be from the same hierarchy-although the members can be from different levels of the same hierarchy.(с)

set is an ordered list of members, or tuples ( co-ordinate to one cell)

As I understand a "member" is 1-co-ordinate tuple

(example : ([Dim_Time].[Time Hierarchy].[Year Key].&[2015])

)

and a Tuple is a multi co-ordinate member
(example: ([Dim_Time].[Time Hierarchy].[Year Key].&[2015]
,[Measures].[Agg_Count])
)

......
Моя компиляция частично отсюда
https://projectbotticelli.com/knowledge/mdx-basic-concepts-unique-names-tuples-sets-video-tutorial
Previous post Next post
Up