Greetings,

I need to create a set from 2 or more dimensions.

For if example [Dim1] has the following members
[Dim1].[M1] and [Dim1].[M2] and [Dim2] has the following
members [Dim2].[M1] and [Dim2].[M2], I need to create the
following set {[Dim1].[M1], [Dim2].[M2]}

I tried using the Crossjoin function but it puts the data
on 2 different axes. Is there any solution for this
problem. Am I missing something simple? Any help wud be
greatly appreciated.

Thanx,
Karthik

All tuples in a set must share the same dimensionality:

http://msdn.microsoft.com/library/de.../en-us/olapdma
d/agmdxbasics_0k8j.asp
Sets and Dimensionality

Like tuples, sets also have dimensionality. As a set is composed of
tuples, so the dimensionality of a set is expressed by the
dimensionality of each tuple within it. Because of this, tuples within a
set must have the same dimensionality. In other words, this example
would not work as a set:

{ (Time.[2nd half], Route.nonground.air), (Route.nonground.air,
Time.[2nd half]) }

The order of tuples in a set is important; it affects, for example, the
nesting order in an axis dimension. The first tuple represents the
first, or outermost, dimension, the second tuple represents the next
outermost dimension, and so on.
...
Hence, a set can't be: {[Dim1].[M1], [Dim2].[M2]}. But if you explain
the objective, another approach may exist?


- Deepak

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!