Every month I judge entries in the TechNet Wiki Guru competition SQL Server Business Intelligence category. Over the years, we have seen excellent contributions and insightful articles about advanced techniques and product tips. The next time you need to solve a particularly vexing BI problem, go to the TechNet Wiki and do a focused search. You’re likely to find useful solutions.
This month, there are three particularly good entries that I would like to showcase. These are all great entries and valuable contributions. The winners we will announced here: http://social.technet.microsoft.com/wiki/contents/articles/33351.technet-guru-contributions-february-2016.aspx
SSIS – Transfer data from Multiple tables using a single DFT
A framework for importing multiple tables and adapting to different column data types. This is a common challenge in large-scale ETL projects that often requires third-party products or deep programming. This approach solves the problem with out-of-the-box SSIS.
DAX: Dates Prior to 1900
A common issue when working with historical dates. These techniques work-around the native data type and DAX function limits with dates earlier than 1/1/1900.
SSRS Tips : Implementing OR Based Logic for Dataset Filters
SSRS report filters are powerful but not always intuitive. This technique applies OR logic to compound Boolean filters to work-around limitations of the designer.