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