cancel
Showing results for 
Search instead for 
Did you mean: 

Options for modeling massterdata attributes which can have multiple values

Ashwin
Active Contributor
0 Kudos

Hallo All BW Experts!

here is a modelling requirement which i find quite interesting and challenging.

How can we use attributes for a masterdata which can have multiplevalues. Currently these kind of attributes are stored in seperate ODS. One example for such a requirement might be the Busines Partner groupes. Each Business partner can be in more than one group.

my question is , How can we modell such kind of masterdata model which enables us to use these attributes for restrictions in reporting from various independent infoproviders. Main problem is due to the condition that the no of such groups per each user is not fixed and can be changed in runtime.

any suggession will be rewarded.

with regards

ashwin

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ashwin,

generally this kind of relationship is obtained only via Transaction data, only the upload of transaction data (invoice - material movements - ...) determine the correct n:m relationship.

Other possibilities are:

Compound: every single value for a Master Data is determined by a combination of Master Data.

Infoset: you create a join beetween two Master Data or one Master Data and an ODS.

Ciao.

Riccardo.

Ashwin
Active Contributor
0 Kudos

Hi Recardo!

you are right correct but i can not use compounding..might be infoset is optimal for such requirement but want to have alternative options. problem with infoset is it cannot be used well with cubes in bw3.5

with regards

ashwin

Former Member
0 Kudos

Hi Ashwin,

you are right about use of InfoSet with cubes.

I canonly suggest you to use InfoSet like DataSource for a MasterData or ODS: you can feed this new object with the values joined by the InfoSet and then use the same in a MultiProvider or in the Cube directly if we are talking of a Master Data.

Ciao.

Riccardo.

Answers (2)

Answers (2)

Former Member
0 Kudos

One approach is find the way to transform a master data in transactional data. For example the manage in BW for personnel manegement, employes is master data with time dependent attributes, from it is generated an infoprovider with store a snapshot of employees by month, hen you can use master data in conjunction with other transactional data.

former_member184494
Active Contributor
0 Kudos

Ashwin,

such cases are called Party Role constructs in a data modeling scebario , they will have a mapping table maintained in them or will have values such as value1 , value2 , value 3 in their attributes.

An example is an appraisal transaction - employee is appraised by manager and manager is also an employee which means that he assumes the role of an employee for his/her appraisal..

a good explanation of the same can be found at

http://www.dmreview.com/article_sub.cfm?articleId=1038793

I know what I have said is not BW specific , but more on the larger scenario of data modeling as such.

Hope it helps..

Arun

Ashwin
Active Contributor
0 Kudos

Hi Arun!

Is there any possiblily to create such a model in BW which is flexible. One option might be to use a heirarchy. Actually the requirement looks like this. We must be able to analyse all businesspartner data and with that data we will be able to group the customers into various target groups. now we want to anyalyse the performance of such target grouops in past time.

to be simple

1) it is possible to create customer groups based on masterdata charecteristics.(there is lot of facilitiey available in BW3.5 and more in 7.0 for this) this is very dynamic

2) Now is it in anyway possible to analayse the performance of such a group. I think currently heirarchies serve such purpose but small limitation in SAP is that they must not contain more than 100000 records otherwise the performance is siverly limited.

any suggestion

with regards

ashwin