Skip to Content
0
Former Member
Jan 02, 2008 at 02:02 PM

Master data modelling optimum way

17 Views

Hi guys,

I am new to SAP BW and I would really appreciate your valuable advice on a subject. I have the following scenario:

There are three entities (banks) that have business partners (clients), approximately 1-2 million each. I would like to store that data in BW. One way would be to use 0BPartner which is the BI Content ready solution of SAP to store all of them using a compound key to differentiate them. The other would be to create three custom info-objects eg. XBPartner, YBPartner and ZBPartner and use each to store the corresponding Business Partner of each bank accordingly. Each one has the same fields and comes from 0BPartner template. The reason to do that would be to avoid having such a huge info-object. Is this a valid reason?

Secondly if I wanted to have a report using data from all three custom info-objects which way would be the best? Maybe an info-set or a multi-cube? Would the entries of the three tables be outer joined this way (like we want them to) or would there be a problem in reporting?

Any help would be kindly appreciated.

Points will be awarded

Regards

Yannis

Edited by: Ioannis Dimopoulos on Jan 3, 2008 8:25 AM