Year 2014 Resolution

Posted by on Dec 31, 2013 in Uncategorized | No Comments

2014 is coming and like many of you I have some resolutions for the New Year. Before that I wish you a new year full of success and happiness. Year 2013 was a year that I did some speaking on webinars such as PASS DWBI virtual chapter, I’ve also done some international speaking such as ...

Read More

Script to Generate and Populate Date Dimension Version 2: Adding Multiple Financial Years

Posted by on Dec 11, 2013 in ETL, T-SQL | One Comment

Almost a year ago I published first version of T-SQL script to generate and populate a general purpose date dimension here. Today I want to publish the second version of that date dimension which has some corrections (fiscal calendar calculation fixed), and additional attributes (such as current year, current month, and current day) Multiple countries ...

Read More

Format String Issue of SSAS Measures in Excel Front-End

Posted by on Dec 10, 2013 in SSAS | No Comments

Most of you faced such situation that you’ve set the FormatString property of your measures in the cube from BIDS or SSDT, But when you browser the cube in Excel you will not see that format. Let’s say you applied format string to add thousands separator, two decimal points, and dollar sign to your Amount ...

Read More