IBP - How to link Master Data together

[willsuus]

I have three MDTs that need to link together to be able to extract the data I need but I can not figure out how to get them to link.

MDT 1: BBResourceLocation - Keys: ResId, LocId / Fields: ZCostCenter

MDT 2: BBProductionResource - Keys: ResId, SourceId / Fields: ZResourceActivity

MDT 3: BBCostCtrResActCurr - Keys: ZCostCenter, ZResourceActivity, Currid / Fields: ZCostCenterPrice

I need to have the following output:

ResId, ZCostCenter, ZResourceActivity, ZCostCenterPrice

I also have 2 additional MDTs - BBCostCenter and BBResourceActivity which are just lists of the valid values for both ZCostCenter and ZResourceActivity.

[willsuus]

In addition, ZCostCenterPrice is an Attribute as a Key Figure

[riyazahmed_ca2 · Accepted solution]

Hi Susan,

You have to restructure your activites as below.

1) MDT1: BBResourceLocation --> Fields: ZCostCenter is not needed here.

2) MDT 2: BBProductionResource --> Keys: ResId, SourceId --> Fields: ZResourceActivity

3) MDT 3: BBCostCenter New MDT to be created. --> Keys: ZCostCenter

4) MDT 4: BBCurrency

5) MDT 5: BBCostCtrResActCurr should be built as the Compound Master Data using MDT2, MDT3, MDT4. --> Keys: ResId(MDT2), ZCostCenter(MDT3), ZResourceActivity(MDT2), Currid(MDT4) --> Fields: ZCostCenterPrice.

You can still keep ZCostCenterPrice as Attribute as Keyfigure in its appropriate level.

Let me know for any questions/concerns.

Regards,

Riyaz

[willsuus · Accepted solution]

How are you getting the link between the resource and the cost center?

1) MDT 1: Resid = ABC, Location = LOC1 *** Needs ZCostCenter = 12345?

2) MDT 2: Resid - ABC, ZResourceActivity = RA1

3) MDT 3: ZCostCenter = 12345

4) MDT 4: Currid = USD

5) MDT 5: Resid = ABC, ZCostCenter = ??? - how does it know that Resid = ABC goes with ZCostCenter =12345 and not some other entry in the table? That is why ZCostCenter is in the MDT 1 structure.

[riyazahmed_ca2]

Hi Susan,

How would you first of all let the system know what are all the cost center does exist? That would be through MDT3 in my previous response. Also we already defined our resources either in BBResource(MDT0) or MDT1. So I proposed the linking of them through the MDT 5 where you define which Cost Center is connected with which Resource.

Any Questions??

Regards,

Riyaz

[willsuus]

Hello Riyaz -

I think I understand what you are saying now. Let me try this configuration and I will report back.

Thank you for your assistance. It it greatly appreciated.

Regards,

Susan

[willsuus]

One additional comment - the reason I didn't have the resource id in the CostCenterResActCurr MDT originally is because it repeated data for each cost center. The value for ZCostCenterPrice is the same no matter what the resource is. So, I was hoping to be able to link the cost center to the resource by having the cost center in the ResourceLocation MDT. From what you have outlined, it appears that this is not doable.