Category: Master Data Services

SAP vs. Microsoft, Information Assets vs. End User Experience positioning

If your company runs SAP, chances are the picture below represents your environment pretty well The black colors represent the existing investments/business processes and the size of the bubbles represents the effort/investment $$$. Your company has made a very large investment in the SAP back-end (ERP, BW, etc.) which is represented by a large black circle

Continue reading

How to create Sharepoint workflow for MDS

Microsoft Master Data Services is one of the most exciting new features of SQL Server 2012.  Technically, the V1 of the product was introduced with SQL Server 2008 R2, but to be completely honest, it did not get much acceptance.  In my prognostication, this will drastically change with the V2 of the product.  There are two

Continue reading

How to expose Master Data Services in SharePoint

I have been hacking around this for a while trying to expose MDS web application in SharePoint.  Apparently, the trick to remove the non-functional UI elements is to use hosted=true query parameter as in http://MDSWebAPP:PortNumber/MDS/Explorer/AttributeSL.aspx?MID=10&VID=23&EID=44&hosted=true#/ExplorerEntity?MID=10&VID=23&EID=44&hosted=true you can find more details on how to do it here

Free technical book “Introducing Microsoft SQL Server 2012” is available for download

The book can be downloaded in PDF , mobi (Kindle) or epub (sony reader) formats… The book does a really good job introducing such new features of Microsoft SQL Server as Data Quality Services, Master Data Services, PowerView and BI Semantic Model.. and it’s free, definitely a good idea to make it part of your technical library. If this sounds like too good of a

Continue reading

Configuring Security for Microsoft Master Data Services in SQL Server 2012

I spent quite a bit of time today troubleshooting a very annoying issue with MDS, which turned out to be a total user error.  For the longest time I could not figure out why my MDS users could not connect to my MDS models.  The confusion stems from the fact that even though you can

Continue reading

Drillable charts in Mcrosoft Office 15

I believe that Microsoft has delivered a very solid release with SQL Server 2012.  I love MDS V2, I am giddy with excitement about columnstore indexes (still trying to hunt down any hints that would substantiate the claimed availability of this technology for Analysis Services), I think that PowerView will be a huge success, although

Continue reading

Breakthrough Insights using Microsoft SQL Server 2012 – Analysis Services

Not sure if anybody is using Microsoft Virtual Academy.. if you are not – you should… What’s the compelling event? Well, 7 freshly minted modules have just been posted for our perusal: Developing and Managing a BI Semantic Model Configuring and Securing Complex BI Applications in SharePoint Enriching your BI Semantic Models with Data Analysis

Continue reading