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
4,162 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,257 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,429 reads
Blogs
Top 5 SQL Server VM Performance Tuning Tips – Webinar Jul 21
By kleegeek
You’re invited! I’m thrilled to be co-presenting a session on the top five SQL...
The Effectiveness of Solar Estimation
By Steve Jones
We added a solar system to the ranch as a way to hedge against...
How do I tell if identity_insert is turned on and if so what table?
TLDR; The code to do this is below but it’s a bit hokey and...
Forums
how to remove duplicate rows in sysobjvalues
Hi, Can you advise how to remove Duplicated rows in sysobjvalues. or remove the...
Few questions about cloud computing course
Hi I'm currently doing a networks management degree level 7. I'm in the final...
Interview question to test beginner SQL competency?
Hello, I need to help my boss come up with a simple-ish SQL quiz....
Ask SSC