What variant of MDX expression will be faster -
11-12-2004
, 07:08 AM
1 variant:
NonEmptyCrossJoin(Generate(Descendants([Goods].CurrentMember,,
LEAVES), {[Goods].CurrentMember.Parent}), {([Measures].[Unit sales],
[Date].[YQMD].PrevMember)})
2 variant:
NonEmptyCrossJoin(Generate(Descendants([Goods].CurrentMember,,
LEAVES), {[Goods].CurrentMember.Parent}), {[Measures].[Unit sales]},
{[Date].[YQMD].PrevMember})
Thanks, Evgeny. |