Tag Archives: MDS
MDS 2012 Installation Issues
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.
Disappearing MDS Model after upgrade to MDS 2012 SP1
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
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.
Continue reading →MDS: Copying models and data to another server – SQLServerCentral
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 →
SSDT Data Source Views and MDS Metadata
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.
Continue reading →Issues with MDS Excel Add-In: Hangs and Attribute Order (Updated 7/19/12)
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 →
Positioning Master Data Services Member Attributes
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 →
“Evaluation period has expired” when installing MDS 2012 alone
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 →
Master Data Services 2012 “Access is denied” error
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 →
