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,622 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,152 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,310 reads
Blogs
Daily Coping 3 Jun 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Lock your Azure SQL Database
By Arun Sirpal
So you have many databases in Azure, you accidentally deleted one which can happen...
BlitzFileStats custom module available for Inspector V2
BlitzFileStats is the latest addition to our custom module collection for reporting on data...
Forums
Changing Connection Managers with the Configuration Manager
OK, this actually not a question, this is in response to a question I...
SSIS How to split a single string into multiple columns using Derived Column
Hello, In my source Column having comma separated with text qualifier(“), I would need...
Licensing Audit Advice
Comments posted to this topic are about the item Licensing Audit Advice
Ask SSC