Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.

Rajesh, just a quick suggestion. I suggest adding a MonthEndDate (or a MonthBeginDate) column to your date dimension. SSAS users typically like using these columns as it ensures that data doesn't get grouped across years (last January and this January in the same column), and it provides a convenient mechanism for ordering a line graph (which sometimes gets rendered in alphabetical order)
– Mark IannucciDec 24 '14 at 16:16

@MarkIannucci I have monthname, date alone and some other columns at Date table. My problem is, I'm getting calculation value greater than the actual value and sometimes it was empty even if it has data.
– RajeshKannanDec 24 '14 at 19:19

@MarkIannucci As I have started working in SSAS, I'm looking to have a in-depth knowledge in it. So kindly provide your valuable comments.
– RajeshKannanDec 24 '14 at 19:23