My Experience

Hi Folks,

In this post I would like to talk about Microsoft Analysis Services. I am amazed by the way Microsoft does aggregations in Analysis Services. Reason for me to write this post is, I ran into problem in Analysis services with Measure. I saw data in Measure, but after processing data was not stored in Measure. So after hours of debuging and analysis this is my finding and trust me it works great. In Analysis service in Calculation there has to be first code with "Calculate" if by mistake this code is either deleted or moved to different level, you will not see data in measure. Take care of this thing in your analysis services