in

Adatis BI Blogs

Browse by Tags

  • 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

  • Master Data Services in SQL Server Denali

    If you didn’t make it to Tech Ed in North America last week, then you can download session recordings and take part in the labs at the Tech Ed site here . The session recordings are also available for streaming or download on Channel 9 . Today I wanted to highlight in particular John McAllister’s session...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 05-27-2011

  • New Master Data Services Book

    For the past seven months, Adatis have been working on new book for Master Data Services. The book, titled SQL Server 2008 R2 Master Data Services, will be published by Packt Publishing and will be released on 30th June. For those of you who don’t know (I certainly didn’t), Packt operate something called...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 04-01-2011

  • Explicit Hierarchies Vs Recursive Hierarchies in MDS

    Derived Hierarchies in Master Data Services are hierarchies created from the domain-based attribute relationships between entities, as explained in the following documentation , resulting in a fixed-depth hierarchy. A less obvious feature is that they can also be recursive, which by its very nature implies...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 02-23-2011

  • Handling of NULLs and Blanks in MDS Business Rules

    For any given entity in Master Data Services, its only the Code attribute that cannot be left blank when entering data in the front end or via the MDS staging tables. For any of the other attributes, you can then use the MDS business rules to enforce that the attribute must have a value, using the Is...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 01-24-2011

  • Master Data Services – Business Rules and the Notification Interval

    For your Master Data services business rules that have a validation action, a notification, if you’ve set one up, will be sent if the rule condition gets satisfied. I’ve noticed a quirk to the way that the notifications are sent – I was getting unexpected email notifications when creating members – which...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 01-12-2011
Page 1 of 2 (16 items) 1 2 Next >