Performing a clean installation of SQL Server 2012 SP1 on the (new) production servers seems to have resolved a number of issues relating to MDS.
My upgrade to SQL Server 2012 SP1 from CU4 went well except for one glitch. After the upgrade was complete, MDS showed no models! … Continue reading →
Is PowerPivot the Next Access? – SQLServerCentral. I have tried using PowerPivot as an alternative to the dreadful, antiquated MS Query, and it does very well, and it can be a decent replacement for Analysis Services when the cube that is needed doesn’t already exist.
MDS: Copying models and data to another server – SQLServerCentral. This SQLServerCentral article caught my eye because it explains a process I will soon be carrying out, moving MDS data from development to production. It looks as though the advice given could save a substantial amount of trial-and-error. Thanks to the … Continue reading →
Summary: When input to an SSDT DSV involves complex metadata such as nested views and/or MDS subscription views, performance of the DSV ‘refresh’ function may degrade to the point where it is unusable. Simplifying the metadata represented by the input solves the problem.
Two major issues have been coming up frequently while using the Master Data Services 2012 Excel add-in. I mentioned the first one earlier: I can’t seem to control the order of attributes in other than the simplest of entities. The MDM move function moves the attributes around, usually, but not … Continue reading →
As far as I can tell, the feature in the Master Data Manager website that lets you edit an entity and reposition the attributes simply doesn’t work, if the entity is sufficiently complex. It appears to move them randomly. When I come back later, they sometimes appear to be back … Continue reading →
It looks as though installing SQL Server 2012 Master Data Services alone on a web server that has no other SQL Server 2102 components doesn’t work out of the box. When you bring up the web page, you see an “Evaluation period has expired” page. Or at least I did, … Continue reading →
Another MDS installation glitch (see here for more). If you create the MDS web application website using the MDS Configuration Manager (using the “New” option in the list of web sites), it may fail to set up IIS authentication correctly. The first time I created the site this way it … Continue reading →