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:
>
Monday, March 19, 2012
MDX: Performance Question
Labels:
91customers,
91myset,
betweenwith,
database,
mdx,
members,
microsoft,
mysql,
oracle,
performance,
select,
server,
significant,
sql,
terms
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment