April 7, 2010

Implementing measure security in SSAS 2008

Recently, I was asked to implement security on a set of sensitive measures, such as profit and all calculated measures on top of them as part of the cube development. It looked like a very straight requirement and I never […]
April 6, 2010

SSRS reports using database images

In one of my first projects, I was asked to store images in database and then use them for my SSRS 2005 reports. The newbie I was, for a moment I was shell-shocked how I could store images in a […]
April 5, 2010

Dashboards in SSRS 2008

To be frank, I was extremely happy when I got to work on SSRS 2008. The 2008 version has changed so much for the better when you compare to the 2005 version, be it on terms of aesthetics or developer […]
April 5, 2010

A better way of showing current year sales vs previous year

Many a times, I have found that all the hard work that I had done behind to optimize and performance tune the reports and OLAP had gone unnoticed when it actually came to showing them to the customer. As a […]
April 4, 2010

Converting multiple rows into a single comma separated row

Recently, I have been bitten by the MSDN forums bug. I enjoy spending time in the SSAS and SSRS forums, and the learning that I take out from there is tremendous. Initially, I just used to read and learn, while […]
April 4, 2010

And here I come!

I have been trying to force myself to the notion of writing blogs for a long time, but then it never happened. I always found myself to be too lazy to pick up a subject, sit down and then write […]