ela_shaked (ela_shaked) wrote,
ela_shaked
ela_shaked

Set vs Member vs Tuple in MDX

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
Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your IP address will be recorded 

  • 1 comment