SQLServerCentral - Guest Columnist: Boyan Penev

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 | 2,855 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 | 5,936 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 | 1,625 reads