For configuring the UI for SRM-MDM, after connecting to the server What userid and the role for the user to login to the MDM repository?. Is UICONFIG role is assigned to the user before login?
Is there any standard userid and role available for configuring the UI?
------------
Hi Steve,
For configuring SRM-MDM UI, user should be assigned UI Configuration Manager role. This role is available in standard shipped SRM-MDM repository. Also this role is by default assigned to user Master. You can add this role to any of the users you want to use to configure UI
How to retrieve Tuple Lookup values using MDM Java API
Instructions for using the Java API with tuples can be found here - link.
The way to retrieve the lookup fields within a tuple is same as other fields inside the tuple. The only difference being other fields return the value direclty when you try to access the field inside tuple. Where as if it is a lookup field then it will retun you the record Id of the value. From this record Id you need to iterate over the lookup table itself to find out what is the actual value.
you need to add the lookup fields in the result definition of the command than only it comes in tuple value. My investigation is If the lookup field is not a main table field, you don't get the value for that lookup in tuple too.
just check it out.
Q:I want to know what are the backend database and tables name where MDM repository data is stored and how to read them.
My intention is to write MS access query to perform a search to retrieve material parts as it is very difficult to do so through front end.(Data manager)
As in front end i need to search one part at a time through free form search.
I am on MDM 5.5 and i use SQL server as my Database.
Ans1:The backend database name for a MDM repository is derived from the repository name (with non-alphanumneric characters removed. A repository named "products" would have an database called "products_M000".
Ans2:
The backend database name for a MDM repository is derived from the repository name (with non-alphanumneric characters removed. A repository named "products" would have an database called "products_M000".
Ans3
Each repository on your DB server will get stored in Databases Folder . Repo can be identified by RepositoryName_m000.
Under this folder tree, 2 folders A2i_CM_Tables and A2i_CM_Fields exist which store the table and field names.
You can read these DB tables from below mentioned options.
1.MS Access > Connect to SQL Source > Define DB Server name > Select Repository name>Choose the table
2. Use SQL Server Enterprise manager > Navigate to required table (table names mentioned above).
Ans4:
It is very difficult to get the entire Table data because there would be few tables corresponding to one MDM table in database hence i will suggest you to try with Expression (part of FreeForm Search) which allows you to write expressions similar to validations and in addition you can use other search parameters of free form search as well.
If you want you can share what kind of search you are looking for, so that we can try with Data Manager only.
Ans5:
My requirement is I want to search multiple material numbers.
The material numbers in my data model is a text field and so i m not sure how to run a query to find out say if 100 mat exist in mdm ?
If you can think of a feasible expression plz help.
Vinay,
As per you,i should not face any major problem to using Access to run this query at the database level.
If so ill be happy to use your suggestion.But plz tell me on which database table should I query and how to get the above result.
If i query on the A2i-CM_tables will i get the extract of the 100 mat i want to search.
-------
Say you want to search whether Material Numbers 100, 300, 500 and 900 exists or not then your Expression would be
Material Number = 100 OR Material Number = 300 OR Material Number = 500 OR Material Number = 900
Click on Browse button of Expression field present under Free Form Search and select the Material Number field from the Fields dropdown (don't write it)
-----------
Thanks for the reply..
ill def try this option..but i am really interested in knowing how to query this frm the database.
As it is really convient to use these MS Access.
------------
Please clarify
Will I be able to see the Main table(products) and the main tables records under the A2i_CM_Tables in the backend database?
If yes,then can i query on this table directly from MS Access and what are the complexities in doing this if any?
-----------
A2i_CM_Tables contains all the tables in Repository . Note the table name or Table ID. Eg.Main table name - Products
A2i_CM_Fields contains all the fields in a given table. Select the table name/id to get the list of all fields in the table .
Note the Field name or field Id that you are looking for .Eq. Product Name.
Write a simple query using above table and field names to search field values.
MDM Repositories not getting loaded in Data Manager
Q:We have 2 MDM Servers one for Development and another for Demo. We were able to access the development repositories through data manager. After we copied the repository from the development server and created the repository in demo server we could not able to load repositories of Development Server.
When we mount the server in both MDM Server and Auxilary server the versions in MDM Server is showing 7.1.01.78 and the same Server in Auxilary server the version is showing 7.1.02.88. I have tested in both the versions of MDM Datamanager to load the repository but I am getting the message as repository not loaded.
Do any one have fased this issue before please share how to proceed further.
Ans:Open MDM Console and mount the development server first, mount the repository (if it is not present) you are trying to access from data manager, login into the repository and check whether it is loaded or not (green triangle along with repository name shows repository is loaded), if not, right click on repository and select Load Repository -> Immediate.
Repeat the same for Demo server.
Ans1:You should also check that all 3 (MDM server, Console and Data Manager) are on the same 7.1 SP (for example, that all are on 7.1.03.xx). If not, then you should install all 3 (and in general all MDM components) on the same SP level, other ways will not work.
Q:We are at SRM-MDM Catalog 3.0 SP02, we enhanced two fields in the contract data which were transfered from the SRM via xml. But when the MDM import manage do the mapping between the xml file and MDM catalog items automatically, it will bring a exception with the mapping error. The error message is "Logon Error: Source file dose not conform to XML schema. Element not found in the xml schema."
How could I add these fields to xml schema?
Ans:Upload the latest xsd file in XML Schemas table present under Admin node of your repository. At the time of import it validates the XML file with its definition stored in this XML Schemas table.
How to add Field to Search in Popup ---- Create iView
We have integrated MDM with EP, using the standard iViews.
I have a create iView (i.e Item Details iViews) , where i am creating a new record.
While creating a new record, there are certain Lookup fields present in them, which has a popup to search for a value in the Lookup table.
As per my understanding in the Popup screen, the user will be able to search by the fields which are marked as display fields in the Lookup table. But it doesnot seem to work that way. Can anybody help me to add some fields to the search in the Popup screen. We are using SAP MDM 7.1
---
The selected fields for searching is not customizable in MDM Standard Item Details iView. Only searchable fields which are configured in the Console as Display fields will be in the search grid of the popup.
----
I have one more question. If there are 3 display fields in a table in MDM, then is it possible to make only 2 fields as searchable in the Portal in the Popup screen?
---
All Display fields will be searchable, this is according to the documentation
We have a Import Map, which the end users uses to do Mass inserts into the Main table as & when required. The end user runs the Import manually from the Import Manager.
We have about 20-25 columns which are of type lookup flat. Hence every time any new values are added to these columns in the source, the user would have to manually go and click on the Automap for values for all the necessary fields.
Is there any property which we can set so that, the Import map automatically performs an value Automap for all the lookup fields when it is loaded?
The source file format is an excel template provided to the user.
We are currently using SAP MDM 5.5 SP06 (Version 5.5.63.73)
Ans:
Refresh all the lookup tables in MDM with remote key mappings.
Then perform perform manual import to Main table. All the Lookup field values will auto map.
Ans1:
Under same configuration optiosn choose and select appropriate values for -
Default MDIS Handling > a. Automap Unmapped handling > Yes
b. Unmapped Value handling > Add
Ans2:
Just check if this happens for all the lookup tables or the only ones used for Matching Records. For second case, use some different matching keys and try the import. Automap feature is available for MDIS only.
How do I reset a field which has type AutoID to start again from count 1 after deleting all the records.Currently it starts from the next sequence.?
Ans:
AutoID field cannot be reset in a repository. This is an internally generated integer by MDM.
You will have to create a new repository using the schema of original repository for new set of Auto IDs starting from 1.
Ans2:Instead of creating new repository, just recreate the AutoID field. This will server your purpose it is not required to create the repository again
We have integrated SAP MDM with the Portal using the Standard iViews provided by SAP.
We have Item Details iViews, which we also use to create a new record in the table. There are some popup buttons for the lookup fields to search for values.
Currently we have set the session time out for portal as 30 mins. If the session is opened for a long time, ie after the session is timed out, we are getting a error {null} in the Portal.
Can we change this and provide a meaningful message. We are using MDM 7.1 SP03.?
---
Solution
The message you are seeing comes from the MDM Connector saying that the connection was already released.
Would be nice to have a "nicer" error message or to be able to change the message at design time, but would be a feature request as it is currently not supported in MDM Standard iViews.
I have 3 fields in main table Field1, Field2 and Field3. All lookups in some table.
If a user enter data let say in Field1 is 001 and Field2 is 002 from dropdown.
In filed3 which is also lookup into flat table Tab1. That flat table contains two fields both are display.
Mean to say while selecting data from drop down we will see like 001,002... 001,003.. 003,005 etc
So user after entering data in field1 and field2 will check that in feild3 that 001,002 exists or not.
Like in this eg. user selected 001 in field 1 and 002 in field2 so in field3 three user will select 001,002 from dropdown.
If he slects different link ..like 001,003 then validaton should fire and say that u have entered wrong link.
In short we need to verify from filed3 that we entered correct link from dropdown which is same as in field1 and field2
if Filed3 is 001,003 or say 001,004 or any other combo not in sync with filed1 and field2 there shud be a validation fire..
Need to know how i can do this in validation..
Ans:
Please use this expression - HAS_ALL_VALUES((Field3.Name1&Field3.Name2),(Field1.Name&Field2.Name))
Where,
Field1 is a field with its lookup field as 'Name'
Field2 is a field with its lookup field as 'Name'
Field3 is a field with its lookup fields as 'Name1' and 'Name2'
Gartner MDM Excellence Award 2009 Goes to Kraft Foods Inc
Dear MDM community,
This is good news for SAP's master data management solution!
At this year's Gartner MDM Summit, the premier industry event for Master Data Management, held 5-7 October 2009 in Los Angeles, Kraft Foods Inc. won the Award for MDM Excellence. The winner runs a central, multi-domain MDM scenario on the basis of SAP NetWeaver MDM. Read more in the Gartner announcement (linked above).
For more details on the scope of their MDM initiative, please see the SAP Press Release (dated September 2008) and the included video (also dated 2008) that shows how Kraft Foods uses SAP technology to track and analyze its master data around the world.
Number two in the race for the Gartner MDM Excellence Award is BP who also runs its MDM strategy on the basis of SAP NetWeaver MDM.
For me, a clear indication that SAP is fully on track with its master data management strategy.
Kind regards,
Markus
BTW - For those of you who attend SAP TechEd, see the MDM tracklist.
