Share via

PEL-MDX terminology comparison

  • Article

Multidimensional Expressions (MDX) language and PerformancePoint Expression Language (PEL) both use the terms tuple and scope, but they use the terms in different ways.

The following list compares important terms in PEL and MDX:

  • Tuple

    MDX: An MDX tuple specifies a member set for one or more dimensions. An MDX tuple specifies, at most, one member set for each dimension. Dimensions that do not have a specified member set are not defined. Instead, when it is used to specify a scope, a default member set is used for dimensions that do not have a specified member set. An MDX tuple that has more than one but not all dimensions specified has no PEL equivalent. Conversely, an MDX tuple that has every dimension specified can be used in instances when PEL would use a TupleSet.

    PEL: A PEL tuple specifies a TupleSet in which each MemberSet contains a single member. That is, a PEL tuple specifies exactly one cell in the model.

  • TupleSet

    MDX: Not defined. An MDX tuple that has every dimension specified corresponds to a PEL TupleSet.

    PEL: A PEL TupleSet specifies a MemberSet that includes every dimension in the model. If a dimension is not explicitly specified, PEL supplies a default value. A PEL TupleSet does not recognize order, and the behavior in the presence of duplicates is undefined. A TupleSet specifies a set of cells in a model.

  • Set

    MDX: An MDX set is an ordered sequence of tuples that may contain at most one member set for each dimension. An MDX set that has one tuple corresponds to a PEL scope. An MDX set with more than one tuple has no PEL equivalent.

    PEL: Not defined.

  • Scope

    MDX: Not defined. An MDX set can specify a scope.

    PEL: A PEL scope is specified by a single TupleSet and specifies a collection of cells in a model.

  • MemberSet

    MDX: Not defined. An MDX tuple with one dimension can be used wherever PEL would use a MemberSet.

    PEL: A set of members. A PEL MemberSet does not recognize order, and the behavior in the presence of duplicates is undefined.

See Also

Other Resources

About PerformancePoint Expression Language
Multidimensional Expressions (MDX) Reference on MSDN