Stack Overflow
Stack Overflow

Questions tagged [master-data-services]

Master Data Services is Microsoft's Master Data Management solution

Master data management (MDM) describes the efforts made by an organization to discover and define non-transactional lists of data, with the goal of compiling maintainable master lists. An MDM project generally includes an evaluation/restructuring of internal business processes along with the implementation of MDM technology.

After a master list is compiled and business processes are set up to support this list, data analysis is more likely to be accurate and business decisions can be based on reliable information.

118 questions
0
votes
1 answer

What causes Unauthorized access error in Master Data services web application?

I have a brand new sql server, IIS and Master Data services installation. The installation went okay, but when I access MDS via the browser, I don't see any models or versions listed in "Model:" and "Version:" dropdowns on the home page for my…
user187809
  • 706
  • 2
  • 8
  • 23
0
votes
1 answer

Master Data Services 2016 data validation: Must be unique in combination

When I save my 'Must be unique in combination with following attributes' with 1, 2 or 3 other attributes, Master Data only saves the first attribute, as I had only choose a 'Must be unique independently'. Any idea? Bug in MDS 2016 SP1? Thanks for…
Gaë
  • 1
  • 2
0
votes
1 answer

MDS Leaf error codes

I am attempting to insert data into a leaf entity within master data services and receiving a error code 256. Checking microsoft documentation such as the below and I cannot find this code.…
Dave Ward
  • 97
  • 1
  • 3
  • 12
0
votes
1 answer

Code Column Read Only Issue in Master Data Services 2016

I have an issue in Master Data Services 2016 my Question is. Our Client wants to see the Code Column in Excel but he is saying that he couldn't Insert or update the Code Value itself in excel . To fulfil his requirement I set the Code value…
Bilal
  • 24
0
votes
2 answers

MDS LastChgUserName

We have been using MDS for a couple of years now and we have noticed that the LastChgUserName field isn't always populated (i.e. its NULL) anyone else notice this or have any idea why this is happening? This is a field that is supposed to be auto…
Daniel Rusch
  • 91
  • 1
  • 10
0
votes
1 answer

Why is the master data service from SQL Server 2016 creating a text field as the primary ID?

If I create a new entity from excel, or from the UI and select "Generate code automatically" for the Code attribute, MDS creates an attribute of the type "Free-form - Data Type : Text, Length : 250" !? Why not "Number, Decimals: 0"?
spikey
  • 444
  • 1
  • 7
  • 27
0
votes
1 answer

Automate Version Validation MS Master Data

Our Company has a Powershell Script in place to update a staging table containing detailed information about all active and non-active servers from a csv file. The staging table is then uploaded to MS Master Data Services 2012 Database through sql…
Paolo R
  • 1
  • 2
0
votes
0 answers

Execute custom sql procedure in MS Master Data Services 2012 Database

My goal is to launch stored procedure from another DB (not MDS DB) when user commits Verion to start ETL process. For that in MDS DB i've added launching custom stored procedure in [mdm].[udpVersionSave]. But when i'm trying to commit Version in MDS…
Михаил Голубцов
  • 1
  • 2
0
votes
1 answer

Master Data Services - Domain based attributes

We are using Master Data Services as an MDM solution for our SQL Server BI environment. I have an entity containing a first name and last name and then I have created a business rule that concatenates these two fields to form a full name which is…
Trevor Howe
  • 1
  • 2
0
votes
1 answer

Master data services 2016 data validation

All modules and attributes are created as per my requirement using Master data services 2016. I am working on data validation. Requirement is that, we have to display custom message to users while he/she is trying to enter duplicate data in the…
Ganesh
  • 266
  • 3
  • 13
0
votes
1 answer

How to use Regex to match a specific character pattern or format?

I am trying to create a Regex pattern that forces a string to match this format: A99.9. (Alpha, Numeric, Numeric, Period, Numeric). I am trying to build this into a business rule in Master Data Services. Anyone have any thoughts?
nation161r
  • 51
  • 1
  • 3
  • 14
0
votes
2 answers

Dedup and Combine Customer Data

I'm trying to combine records based on the ClusterID to have an enriched data of customer records. How will I be able to group the following using MS SQL? Coalesce won't work as records need to be on the same row to make it work, and if I have more…
mtryingtocode
  • 939
  • 3
  • 13
  • 26
0
votes
0 answers

MDS DBAListRowLimit don't affect max number of items in drop down list in Excel add in

First time I changed DBAListRowLimit in mdm.tblSystemSetting from 50 to 10000 it affects in Excel addin. So I see the drop down list with number of items more than 50 and less then 10000. After that I changed it back, but MDS Excel addin didn't…
Boris Bondarev
  • 1
  • 1
0
votes
1 answer

Master Data Services Web Application Issue

I am trying to create a Master Data Service Web Application. So far, I have not succeeded with this activity. I have check on internet for possible solutions but: The .NET 3.5 and 4.5 features are checked, the svc file is present, but everytime I…
d2907
  • 798
  • 3
  • 15
  • 45
0
votes
1 answer

Write MDS business rules directly in SQL

I'm using Master Data Services to check business rules in SQL. The use of MDS makes it easy for any (non-coder) to add business rules. However, I initially need to add a large amount of business rules and this is a very tedious procedure in MDS. Is…
Jan Willem Timmer
  • 1
  • 2
1 2 3 4 5
6
7 8