Skip to Content

Uniqueness of a master data

Hi experts,

I have to create a new Master Data in BW. The issue is that 5 fields ensure the uniqueness of a record, below an example:

account

func area from

func area to

profit center from

profit center to

virtual account

6010101

0

0

1050013

1050013

R96101M

6010101

39

1050013

1050013

R96101M

6010101

0

0

1100016

1100031

R96101M

6010101

39

1100016

1100031

R96101M

6010101

0

0

3010101

3010206

R96101M

6010101

39

3010101

3010206

R96101M

6010101

0

0

3010208

3031443

R96101M

6010101

39

3010208

3031443

R96101M

I tought about creating the green fields as compounding. What do you think? Is that technically possible? Any other ideas?

Thanks for your support.

Amine

Add a comment
10|10000 characters needed characters exceeded

Related questions

9 Answers

  • Best Answer
    Posted on May 30, 2013 at 09:54 AM

    Hi Amine,

    Green Flag from my side as well.But this is important before you implement this model:

    A maximum of 13 characteristics can be compounded for an InfoObject.

    Note that characteristic values can also have a maximum of 60 characters.

    This includes the concatenated value, meaning the total length of the characteristic in
    compounding plus the length of the characteristic itself.

    Hope that helps.

    Regards,

    AL

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 30, 2013 at 09:29 AM

    it's the best choice, else the values will be overwritten.

    if you want all in one field, then solution would be to write a routine in the transformation and use concatenate to put it all in one field. but this is less interesting.

    BR,

    M.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 30, 2013 at 09:38 AM

    Hi Amine,

    You have a composite key, and as you answered your question, the best way is a COMPOUNDING attribute. Having all in one field is a good option, but might make it tough to read the data. Compounding sounds to be the best way out here.

    Regards,

    Manohar. D

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 30, 2013 at 09:44 AM

    Hi Amine,

    Your idea of "Compounding" is the perfect approach to achieve uniqueness.

    Using compounded InfoObjects extensively, particularly if you include a lot of InfoObjects in compounding, can influence performance.

    Regards,

    Suman

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 30, 2013 at 09:48 AM

    Hi Amine,

    Compounding options was best one. if you go with routine, its may impact your loading performance slightly. master data may load always full load. your option was good. go on.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 30, 2013 at 10:09 AM

    Hi Amine,

    Another idea is compounding a sequence number.

    e.g.

    account 1, 1, <other values...>

    account 1, 2, <other values...>

    account 1, 3, <other values...>

    Regards

    Bill

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 30, 2013 at 10:41 AM

    Thanks Guys,

    @Anshu, lf my compounding produces a total lenght of 66 instead of 60. How can i bypassit?

    Thanks.

    Amine

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 30, 2013 at 10:51 AM

    Yes in that situations we will create compounding attribute on that objects or Else the records will get overwritten.If you have same combination of objects coming from both the files, then you need to have 0SOURCESYTEM in the compounding.If you add 0SOURCESYSTEM in the master data, then you have to populate this in the transaction data where you are planning to use this infoobject.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 30, 2013 at 11:24 AM

    Hi Amine,

    Please make a note that your master data nfoobject itself is also a part of Key field along with Compunding. And master data IO must exist to add Compounding in that, so in your case according to data you have shown, Account will be master data IO and other 4 fields will be placed in Componding.

    And if my understanding is wrong and you are talking about additional 5 fields along with 1 master data IO, then means you have total 6 fields to make record unique then its correct that you will add this 5 fields in Compounding. but i think that is not the case. you have only 5 fields to make record as unique as shown in your query.

    Regards,

    Dipti

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.