Business Intelligence Blogs

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.

26 January
2014
Author: okeofs

Master Data Services for the Beginner Part 01

About 12 months ago, I started to look at Master Data Services in a serious manner. I had toyed with the product in SQL Server 2008 R2 but (like others did) found it very awkward to work with and difficult to understand. Microsoft has done a super job with this version and this sparked me into...
25 January
2014
Author: okeofs

Master Data Services Disaster Recovery Challenges

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.

02 January
2014
Author: okeofs

SQL Server 2014: Master Data Services..Backing up your data models.. A necessary evil!

When dealing with Master Data Services (hence forward referred to as MDS), aside from the routine backup of the MDS database, it is imperative to back-up your models (with their data), so that one is able to ‘roll back’ in case of a ‘whoopsie’ and THIS is what I shall be...
23 December
2013
Author: okeofs

Master Data Services 2014: Creating nightly load processes

A few days ago, I ran into an interesting issue when creating a stored procedure to load new data into a 2012 Master Data Services entity via a staging table and a SQL Server stored procedure. This article shows how I created and assembled the necessary fields and data in the format necessary to...
26 November
2013
Author: okeofs

Setting your predicate arguments at run time Part: 2 MultiSelect

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)

24 November
2013
Author: okeofs

Setting your predicate arguments at run time

This article shows how one may set your query predicate parameters at run time, by setting the arguments dynamically.

02 August
2013
Author: okeofs

Flexible Fiscal Data Sorting

Presenting data for a custom fiscal year

24 June
2013
Author: Steve Simon

Dynamic calculations of running totals

Dynamic calculations of running totals