Env: SQL Server 2012

I'd like to import some tables into MDS entities.

So I found MDSModelImport Program.

Importing is worked. And I confirmed to imported columns of tables as leaf Attributes.

I tried to insert data. But In Explorer Leaf Attributes are not shown except Code and Name.

So I couldn't insert data. In Excel also it does.

 

• Edited by Takatoshi Nao Tuesday, August 25, 2015 2:33 AM

Hi Takatoshi,

According to your description, you are experiencing the issue "Leaf Attribute imported from MDSModelImport Not Appeared to Explorer " when insert data to table in Master Data Services, right?

One of the new features of MDS in SQL Server 2012 is a new process for staging data to be imported into MDS.  Key things to be aware of:

• Each entity has its own staging table in the stg schema.
• Each entity has its own stored procedure (udp) to load data from staging into the model.

Leaf Members

•  Staging table:  stg.EntityName_Leaf
•  Stored procedure to load model:  stg.udp_EntityName_Leaf
•  View which displays errors: stg.viw_EntityName_MemberErrorDetails

Please refer to the link below to see the details.
http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/02/16/importing-data-into-master-data-services-2012-part-1

Regards,