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,472 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,150 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,304 reads
Blogs
Error message: http://System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value ‘NULL’ to data type int.
I love this error. Primarily because it demonstrates two very important things. Errors matter....
New Power BI Report Design Pre-Con in 2020
I’m excited to announce that I will be offering a full-day pre-con about Power...
Resetting an Azure SQL Database Admin Password
By Steve Jones
This is likely something that most people know, but it was a bit confusing...
Forums
Deadlocks
Looking for some ideas so to prevent deadlocks. I have captured queries that constantly...
Lengthy query response times
I'm dealing with a strange problem that started today. A simple query that will...
Query runs for days when upgrading to 2017
We upgraded our datawarehouse sql server from 110 to 140, RTM - CU17. In...
Ask SSC