in

Adatis BI Blogs

Browse by Tags

  • Debug Custom MDS Workflows

    The custom MDS workflows, AKA External Action Business Rules or custom MDS assemblies, are one of the more advanced features of MDS. They allow you to extend the standard MDS business rules by getting MDS to fire Entity Member member data at an external assembly of your choice. There are a lot of moving...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 05-20-2013

  • Unique Values in Master Data Services

    I’ve been doing quite a few demos and Proof of Concept (POC) projects recently for MDS. Understandably there are always a raft of questions that come up during demos and POCs, one of which recently was “how do I ensure that this attribute’s value is unique?”. MDS can easily deal with simple uniqueness...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 12-07-2012

  • Master Data Services SQL Server 2012 Vs 2008 R2

    I’ve given quite a few MDS demos recently and one question I seem to get asked often is “What features does MDS 2012 have compared to MDS 2008R2?”. As its happened quite a few times, I thought it would be a good idea to put a quick post together to explain the differences. The table below details all...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 11-09-2012

  • Matching with Master Data Services, DQS and SSIS

    If you have an MDM requirement to consolidate multiple sources of Master Data together into a single golden record, then you have a few different ways to achieve this on the Microsoft platform. This blog post gives an overview of the different ways that various matching methods can be used in conjunction...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 10-11-2012

  • Master Data Services in SQL Server 2012 RC0

    There’s been a whole host of changes to MDS in the SQL Server 2012 RC (Release Candidate) 0 that came out the other week. This blog post gives an overview of the changes, before diving into detail on a few of them. At a high level, the following changes have been made to MDS: Improved Master Data Manager...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 11-30-2011

  • Managing SSAS Named Sets with Master Data Services Collections

    Master Data Services Collections are probably not the first feature that come to mind when you think of the MDS product. The hierarchies and member grids tend to be the core functionality, but as this post will hopefully show, MDS Collections are useful also. Collections are essentially managed lists...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 11-07-2011

  • Master Data Services Kindle Contest

    This is a quick blog post to announce that Adatis are running a contest in conjunction with Packt around Master Data Services. The winner will receive an Amazon   Kindle pre-loaded with our Microsoft SQL Server 2008 R2 Master Data Services book. In order to enter, all you need to do is follow @AdatisBI...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 09-13-2011

  • Master Data Services Excel Add-in

    Master Data Services in SQL Server Denali now includes an Excel add-in that allows MDS users to add and update data that exists within Master Data Services. For those of you that haven’t had a chance to download the latest CTP, this post gives an overview of what’s possible in the Excel Add-in. Excel...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 08-25-2011

  • Master Data Services Training

    As I’m sure you’ve seen, registration for SQLBits 9 – Query Across the Mersey is now open. This time around I’ll be running a deep-dive training day with Tim Kent on Master Data Services. This will be a full day of training, showing you how MDS can be used to manage the master data in your organisation...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 08-22-2011

  • A Pattern To Load Data to Master Data Services via SSIS–Part 2

    Introduction This is the second part of a series of blog posts intended to show a way to load data in to MDS via SSIS. In part 1 we have loaded the staging tables with new members and attributes for several entities. In this blog post we are going to extend the SSIS package with tasks to move the data...
    Posted to Neil Dobner's Blog (Weblog) by Neil Dobner on 08-18-2011
Page 1 of 2 (20 items) 1 2 Next >