MDX: Another performance question -
03-22-2005
, 04:26 AM
Hi,
In terms of performance, what is the difference between:
CrossJoin([MySet], [MyOtherSet])
AND
Generate([MySet], CrossJoin([Dimension].CurrentMember, [MyOtherSet]), All)
// Where [Dimension] indicates the dimensionality of [MySet]
And in general - are there anything special I need to consider before I use
the Generate function, from a performance point of view?
Thanks.
John. |