Custom Rounding and Truncation of Numbers in MDX
MDX applies "bankers' rounding" algorithm in its ROUND() function. This article shows you how to avoid that and round like in T-SQL and Excel.
2009-10-06
3,387 reads
Boyan Penev
Reporting Services Styles in a Database Table
A follow-up on Adam Aspin's series about SSRS styles. I have emailed Adam the article because he suggested it would be good to have one here after his works get published.
2009-03-26
7,149 reads
Filtering Unneeded Dimension Members in PerformancePoint Filters
Removing redundant dimension members from a Tree filter in PerformancePoint 2007 by using a simple MDX query.
2008-11-14
2,297 reads
Blogs
Trailing Spaces in SQL Server
By Bert Wagner
Watch this week’s episode on YouTube. A long time ago I built an application...
Trello For The User Group
By Andy Warren
I’m trying Trello this year to manage both SQLSaturday and our other events. Part...
SQL Server Containers Are Boring
Not really, but sort of. The beauty of containers, at least in a dev/test...
Forums
Statistics Profile Results
Comments posted to this topic are about the item Statistics Profile Results
SSMS Standard Reports Error
I think I'm finally beginning to figure this out, but I need some assistance...
Report copy of 2008R2 on 2017
Hi all , we have a proprietry 2008R2 Standard OLTP db which is...
Ask SSC