View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.
While Master Data Services is the best tool to come along to permit user to update their qualitative and quantitative data, disaster recovery from the failure of a model or the MDS database itself can be a challenge to say the least.
This article is part two of an earlier article. It shows the method that I use (as a standard), to multi-select items from SSRS drop down boxes. This technique is used to filter the returned dataset (which is eventually used by the SSRS matrix)
This article shows how one may set your query predicate parameters at run time, by setting the arguments dynamically.
I will present some simple techniques to convert "Procedural SQL" into "Set based SQL" that might help you write better SQL :).
Dynamic calculations of running totals