Groups | Blog | Home
all groups > sql server reporting services > october 2006 >

sql server reporting services : matrix showing wrong totals


Brian L
10/11/2006 11:08:01 AM
Going bonkers here. I have a matrix that displays total referrals by month
for the year. Two months, Feb and April are off by 1 when I view the matrix,
but other months show correct amt. when just doing a simple query with same
criteria, the dataset is correct. I've looked at the data countless times
but cannot deterine where the issue is. Possible matrix problem? anyone seem
results llike this?

Brian L
10/11/2006 11:46:02 AM
more food for thought. I changed the query a bit. rather than selecting all
companies who referred to us, I selected just one. Results were accurate with
just one referrer. I'm still perplexed though....

[quoted text, click to view]
aaron.kempf NO[at]SPAM gmail.com
10/11/2006 2:59:12 PM
are you using olap or relational?

sounds like a standard olap situation where you need to write some
crazy-ass MDX statement

-Aaron


[quoted text, click to view]
AddThis Social Bookmark Button