mdx中元组和集合的区别 [英] Difference between tuple and set in mdx

问题描述

MDX 中的 tuple 和 set 有什么区别.我们如何区分两者以及何时使用它们.

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

推荐答案

元组是从所有维度中提取的单个层次结构成员.假设 Time.[2nd half] 是一个时间维度的元组.同样，我们可以有多个元组，并将它们表示在 '(',')' 括号中.例如:

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).

这只不过是节点的数学交集.我们可以用与上述表达式相同的方式将数学中的节点表示为 (2,1).

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.

现在来设置它只是元组的组合.set 包含一个或多个元组，它也可以归零.我们用 { , } 大括号表示它们.例如:

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) }

这篇关于mdx中元组和集合的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！