Prevent Divide by Zero in SSRS

In a previous post, I wrote about how to prevent the divide by zero issues in Reporting Services. The problem with the custom code I used was that the code returned the value 0 when one of the numbers is 0 or unknown. So when the outcoming was NULL, the code returned 0. This result in

Calculate Lost Customers using T-SQL

A common question in the Business Intelligence world from customers is “how many customers did we lose this year” ? Businesses wants to know this so they can act faster to keep customers doing business with them. In this article, I will help you to create SQL to calculate

Interesting Course about data visualisation from Google

Making Sense of Data   Do you work with surveys, demographic information, evaluation data, test scores, or observation data? Are you interested in making the data you collect more useful by organizing it, analyzing it, and applying it in different ways? This self-paced, online co

New SQLBlog.nl Logo

Sqlblog.nl exists 4 years now and I thought it was time for a new design and logo for Sqlblog.nl. Today I am proudly to present the new Sqlblog.nl Logo, thanks to KeviG for his effort. I hope you like it. I also did some new styling to the site to make it more user friendly.

Dynamic Refresh SSRS Cache Using SQL

I am working for a client which uses a Datawarehouse in which the data is loaded once a day during the night. During the rest of the day, nothing changes in the datawarehouse. After a couple of years, the database grows and grows and reports are getting slower and slower. Another prob

Calculate time in hours and minutes between two dates

 Sounds easy right? I want to calculate the difference in hours and minutes between two dates. A good readable notition for my report. I want a format like this: 00:36:53 OR 02:13:45 This can easy be done using a T-SQL Statement like this: CONVERT(nvarchar(64), EindDatum-S

SSAS: How to format a dimension attribute?

 I was looking for a method of formatting a dimension attrbibute in SSAS2008R2 to, for example a currency symbol €. In search of this question, I found out this is not possible within the default SSAS settings (format column). I thougt this was possible just like the measures settings

Microsoft Power BI

 Microsoft heeft leuk nieuw speelgoed geintroduceerd genaamd Power BI. Het ziet er veelbelovend uit, al heb ik nog niet de mogelijkheid gehad om ermee te testen.   Origineel artikel van de Microsoft website Hier nog een artikel op computerwereld.      

Powerpivot 2010 architectuur

Ik kwam vandaag een leuke pagina tegen op de Microsoft site. Je kunt hem downloaden van de Microsoft site.

SSRS2008R2 – Keep Header Visible While Scrolling

Als je in SSRS2008R2 een rapport maakt en je wilt dat de bovenste header vast blijft staan als je naar beneden scrollt dan zal je normaal gesproken verwachten dat de optie “Keep header Visibile While Scrolling” dit regelt. Niets is minder waar. In SSRS2005 werkte deze opti