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,428 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,298 reads
Blogs
Check Query Progress with Live Query Stats
This is something I touched on back in 2017 a little after the Live...
SQL Server 2019 on Docker no longer runs as root by default
In my home lab I have an Ubuntu virtual machine that runs both SQL...
SQL Server 2019 – Compatibility Level in Azure
By Arun Sirpal
I am not sure when this became available but for Azure SQL Database 150...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
SSIS catalog deployment from source server to target - powershell
I am looking for a good solution for automating the deployment of SSIS packages...
XML Data singleton value not fixed????
Hi Hope to explain this correctly I have some XML data that can vary...
Ask SSC