MDM Material Data and BI

[Former Member]

I have a customer that will be sending material data from MDM to BI. In BI, they will be doing reporting using certain navigational attributes we've developed. From our experience, the process of using the navigational attributes seems slow as you step through and give each one a criteria.

Does it makes sense to do the lookup in MDM and send a list of material numbers to BI. I am thinking that might be faster but, he have no idea how this could be accomplished technically. Do you have any thoughts on using MDM to perform a quick search to get a list of materials and then sending the list to BI as the source for the reports.

Thanks

Paul

[Former Member]

Hi Paul,

If you are using MDM with BI then the intention is to perform correct reporting on the Cleansed and deduplicated master data as maintained in MDM.

For doing this you will have to maintian the Material numbers in the Main table and not in any lookup as the matching merging can be excuted on the main table records only.

Besides if you want that MDM syndicates only a set of Material numbers with just the Global id as generated in MDM and the local id as original then you will have to accordingly create a syndicator map which will be syndicating on these 2 concerned field values to BI.

Also if you want that only a selected few material numbers get syndicated then accordingly you will have to put a search on the Material number fields.But this will be a very static approach.

Hope It Helped

Thanks & Regards

Simona Pinto

[former_member208981]

Hi Paul,

Under the Syndicator's search parameters, goto the Free-Form Search and create search criteria in the Expression entry.

You can use it to get only those records you want to work on further in BI.

Hope it helps.

Thanks,

Priti

[Former Member]

Hi Paul,

I have a customer that will be sending material data from MDM to BI. In BI, they will be doing reporting using certain navigational attributes we've developed. From our experience, the process of using the navigational attributes seems slow as you step through and give each one a criteria.

Does it makes sense to do the lookup in MDM and send a list of material numbers to BI. I am thinking that might be faster but, he have no idea how this could be accomplished technically. Do you have any thoughts on using MDM to perform a quick search to get a list of materials and then sending the list to BI as the source for the reports

In case of MDM and BI integration, there are several ways to perform the same.

1. Using File transfer system - As you have mentioned that in BI we define navigational attributes and transfer the Master data in the form of a .CSV file to BI, which then can report on both the Local Id's and the Global Id's.We had done this scenario with MDM SP04 and the reporting seemed to be good at that time.

2. With higher versions of MDM, there is a direct integration of MDM with BI using ABAP APi's. INfact the repository was created from BI in MDM server and only Data Manager is used in that case. You can go for this method as well. Plese find the link below to understand the same.

Integrating MDM with BI 7.0 Using Logical Connection Object, Part 1:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b01e4269-f744-2b10-929b-fa7b49aa...

Integrating MDM with BI 7.0 Using Logical Connection Object, Part 2:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d06a92de-614e-2b10-4989-d913c215...

Integrating MDM with BI 7.0 Using Logical Connection Object, Part 3:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00f0d853-936f-2b10-1880-d3deb1fb...

http://help.sap.com/saphelp_nw70/helpdata/en/45/5d3bfaa9ef3bdfe10000000a1553f7/frameset.htm

3. Now coming to your requirement, if you want to use searches in MDM, then you can definitely do that in MDM. The records which get selected in the search creteria can be then syndicated to BI using the File transfer mechanism. This might increase up the speed as only few records will be syndicated as per the search creteria set. You can set the search in Syndicator directly.

Hope this info helps.

Thanks and Regards

Nitin Jain

[Former Member]

Hi Paul,

You can set the search criteria in MDM Syndicator by selecting the desired material numbers and save the map. Now everytime you syndicate data out from MDM it will syndicate only the records satisfying search criteria. But this criteria would be fixed and if you have 2-3 search criterias then you need to create 2-3 maps i.e. one for each.

Regards,

Jitesh Talreja