Friday, February 24, 2012

CrossJoin of two large sets....

I am looking for the best way to display a date related to a lot.

The problem is when I cross join to a date dimension the performance is terrible. Is there anyway to improve performance?

Code Snippet

WITH

MEMBER x

MEMBER y

SELECT NON EMPTY { [Measures].[X], [Measures].[Y] } ON COLUMNS,

NON EMPTY { ([Lot].[Lot].[Lot].ALLMEMBERS * [Voter Source].[Voter Source Code].[Voter Source Code].ALLMEMBERS)* [Date].ALLMEMBERS ) } ON ROWS

FROM [CUBE]

What do the definitions of X and Y look like - that would affect performance? And how many empty cross-joined rows are to be eliminated?

No comments:

Post a Comment