SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Boyan Penev

SQLServerCentral.com profile

   Items 1 to 3 of 3   

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.  Read more...
By Boyan Penev 2009/10/06 | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 3,349 reads

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.  Read more...
By Boyan Penev 2009/03/26 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 7,143 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.  Read more...
By Boyan Penev 2008/11/14 | Source: SQLServerCentral.com | Category: performancepoint
Rating: |  Discuss |   Briefcase | 2,288 reads
   Items 1 to 3 of 3