Home Dashboard Directory Help
Search

Performance Degradation with the Aggregate Function and Unrelated Dimensions by Teo Lachev


Status: 

Active


6
0
Sign in
to vote
Type: Bug
ID: 778563
Opened: 2/5/2013 5:33:34 AM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

When Aggregate function is used with a unrelated (hanging) dimension (a dimension that doesn't join any measure group), the query has a very poor performance. Replacing Aggregate with Sum fixes the performance issue.
Details
Sign in to post a comment.
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
AW.zip 2/5/2013 546 KB