Monday, March 19, 2012

MDX: Performance Question

Hi,
In terms of performance, is there a significant difference between:
With [MySet] as '[Customers].Members'
Select {[Measures].[Unit Sales]} on Columns,
Union(
CrossJoin([MySet], {[Dimension].[MyMember]} ,
CrossJoin([MySet], {[Dimension].[MyOtherMember]}
)
on Rows ...
AND
With [MySet] as '[Customers].Members'
Select {[Measures].[Unit Sales]} on Columns,
CrossJoin([MySet], {[Dimension].[MyMember], [Dimension]
.[MyOtherMember]}) on
Rows ...
?
Thanks in advanceNo, there shouldn't be.
Chris
http://spaces.msn.com/members/cwebbbi/
"John" wrote:

> Hi,
> In terms of performance, is there a significant difference between:
> With [MySet] as '[Customers].Members'
> Select {[Measures].[Unit Sales]} on Columns,
> Union(
> CrossJoin([MySet], {[Dimension].[MyMember]} ,
> CrossJoin([MySet], {[Dimension].[MyOtherMembe
r]}
> )
> on Rows ...
> AND
> With [MySet] as '[Customers].Members'
> Select {[Measures].[Unit Sales]} on Columns,
> CrossJoin([MySet], {[Dimension].[MyMember], [Dimensio
n].[MyOtherMember]}) on
> Rows ...
> ?
> Thanks in advance
>
>|||Thanks Chris.
John.
"Chris Webb" <OnlyForPostingToNewsgroups@.hotmail.com> wrote in message
news:D0668972-B3F2-42F0-9317-259277B3042A@.microsoft.com...[vbcol=seagreen]
> No, there shouldn't be.
> Chris
> http://spaces.msn.com/members/cwebbbi/
> "John" wrote:
>

No comments:

Post a Comment