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
4 answers

Master Data Services deleting rows from UI

We have duplicate data in entities in Master data services and not in staging tables. how can we delete these? We cannot delete each row because these are more than 100?
Durga
  • 33
  • 5
0
votes
1 answer

Insertion in Leaf table in SQL Server MDS is very slow

I am using SSIS to move data from an existing database to an MDS database. I am following the following Control flow; Truncate TableName_Leaf Load Data to stg The second step has the following data flow: 1. Load data from source database (This has…
Shaswat Rungta
  • 3,635
  • 2
  • 19
  • 26
0
votes
5 answers

Master Data Services

I'm a SQL Server developer learning MDS. I loaded some entities via staging tables and via Excel add-in. I'm trying to update members in an entity in MDS via the staging table. I can successfully add new members, but any attribute updates to…
Durga
  • 33
  • 5
0
votes
1 answer

Data Validation Master Data Service

I'm currently working on a POC MDS/MDM WCF service and have a question regarding validation. Does anyone have an example of calling the MDS web api to kick of validating the MDS model? I know i have to add a service reference to MDS in order to gain…
puffspluss
  • 1
  • 1
0
votes
1 answer

Masterdata Services udpValidateModel Procedure

i've got a few tables in MDS. One table (clients) ist filled via SQL and the other one is a masterdata table (country) filled by hand. I have a business rule on table clients: "Name must be unique" and no b-rule on Country. I want to validate the…
user1595837
  • 1
  • 2
0
votes
0 answers

Options for Database Managers for SQL Server and MDS

I am looking at ways to visualize my database for non-technical end users. I want them to only have access to views (triggers can be put on views to enable updating) and let them add, delete and modify data. It should be a simple software (hopefully…
Ben Finn
  • 1
0
votes
1 answer

Master data services authentication through url

I'm new to Master data Services (MDS) and I would like to know if it is possible to authenticate MDS through url. The reason why I'm asking is we have a web application which contains a link to the MDS and we would like to connect to MDS with the…
Syuzi
  • 1
  • 3
0
votes
1 answer

MDS excel add in issue while selecting values in domain based attribute

When I am trying to select a value in domain based attribute using MDS Excel Add in, I am getting a long list of BLANK values in the dropdown. These blank records does not exist in my MDS database. Wondering from where these records are coming in…
Prashant Bhosale
  • 1
  • 5
0
votes
1 answer

Master Data Services Data import syserr 207

I have built a relatively simple data model and I am trying to import data into it for the first time using SSIS. I fallowed this tutorial http://www.sqlchick.com/entries/2013/2/16/importing-data-into-master-data-services-2012-part-1.html but after…
Brandon Peterson
  • 3
  • 1
0
votes
1 answer

How to mark a cell as changed so its value will be published to MDS?

I am writing some Excel VBA code to go along with the MDS add-in so our users will have an easier time sorting, filtering, and publishing data. The code I wrote populates some cells with data from another sheet whenever the user makes a change in a…
Tony
  • 43
  • 1
  • 2
  • 7
0
votes
1 answer

Lost Administrator Permission in Master Data Services (MDS)

I was exploring & experimenting Master Data Services of SQL Server 2012. I have discovered that read only functionality is available for the attribute (column). I have marked a column as read only & it worked; however, I have lost all admin…
BI Dude
  • 1,842
  • 5
  • 37
  • 67
0
votes
1 answer

How can we restrict the other user to change the record which has been entered by particular user in MDS

I have created Product entity in MDS. It's having the following values: Bike 1 ABC Car 2 XYZ Cycle 3 RRR owner XYZ can change the record of RRR. But if owner XYZ or any other owner in this entity tried to update the ABC's record, access…
user3607647
  • 51
  • 2
  • 14
0
votes
1 answer

How can we display user who loading the record in MDS

How can we display the owner of the record automatically in MDS. For Example, I have 2 groups called Group A and Group B. Group A user entering the record as following: NAME CODE Bike 1 Car 2 Similarly Group A user entering the record as…
user3607647
  • 51
  • 2
  • 14
0
votes
1 answer

Installing MDS Excel Add-In Issue with Prerequisites

I am attempting to install the Master Data Services Plugin for Excel, but can't get the install to actually process due to it saying the prerequisites are not installed: I have made sure I have the right version (32 bit) to match my version of…
Josh Jay
  • 1,240
  • 2
  • 14
  • 26
0
votes
1 answer

Master Data Explorer disables Model and Entities after every action in Excel

I'm working with SQL Server 2014 and Excel 2013 with the Master Data Services Add-on (SQL Server and Excel are both trial versions.) When I connect to the model then I perform any action on an entity in that model, the Model and the list of Entities…
user167908
  • 977
  • 2
  • 9
  • 11
1 2 3 4 5 6
7
8