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,677 reads
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,677 reads
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,480 reads
Removing redundant dimension members from a Tree filter in PerformancePoint 2007 by using a simple MDX query.
2008-11-14
2,521 reads
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
By Ed Elliott
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...
hi, my new user provided a new multi tab (sales, customer etc. not what...
If I configure remote access to 0 on my servers, am I right in...
What is the best way to set the schedule of a maintenance plan or...
I am trying to analyze a number of columns in a large table to determine the highest value for each row. In SQL Server 2022, we have the GREATEST function, which will return the greatest value from those columns passed in. How many columns can I include in an expression like this:
select GREATEST( col1, col2, col3, ...)See possible answers