Skip to Content
author's profile photo Former Member
Former Member

Infoobject Compounding v/s Concatination

Hello Guys,

Can you give some pros and cons of doing compunding v/s concatination of Infoobject.

For Eg, we have created a datasource for Batch classification and when have to extract data in to BI we have a confusion of either going for compounding of 0MATERIAL or Concatinating of 0MATERIAL with 0BATCH.

Suggestions are appreciated with Points.

Thank u,

Vamsi.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 04, 2008 at 05:21 PM

    your reporting requirement and your user acceptance shoudl drive the decision.

    Realistically, I would compound the material to batch as it would be easier on users and easy to maintain for you too.

    But both the ways it would work.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 04, 2008 at 05:23 PM

    You should use compounding.

    Consider, for example, a DB table that requires two fields for the primary key. Would you create two columns or just one column and put concatenated value in it?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 04, 2008 at 05:26 PM

    Yes - Compounding will be better option.

    With the help of Compounding attribute, you determine whether or not the characteristic is to

    be compounded to other InfoObjects. We often need to "compound" characteristic values to enable characteristic values to be assigned uniquely.

    Eg: Cost center 100 stands for sales and distribution in controlling area 1000,and it also stands for sales in controlling area 2000. In this case, you would define a "cost center" to "controlling area" characteristic compounding. In addition, compounding can be used to define dependencies between objects. This simplifies navigation in reporting.

    Add a comment
    10|10000 characters needed characters exceeded

    • Compounding:

      Say we have employees in many countries,

      and these employees can have same id,

      country employee id

      india 001

      india 002

      usa 001

      usa 002

      if we only use employee id and extract data to bw from these countries and 001 from india and 001 from usa will overwrite each other, so we need to compound employee with country.

      And reporting also we can display report country wise which will be pretty clear.

      For more example:

      Concatenate:

      In case of concatenating, we are combining two or more values into one and when you will report with say above example country/employee id, you can't separate country wise. Two values will be displaying as one record and will not be that much user friendly but our job is to make the report as simple as possible so that user can understand easily.

      Hope it helps..

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 07:12 PM

    Before you compound 0material you have to analyze your BW system. Where is 0material used? In order to compound an info object all transaction data and master data must be deleted and then reloaded. Can you do this? How much transaction data exists in BW that has 0material as a characteristic? Ask the question, What am I trying to accomplish in BW by compounding 0material? Is it only to be used for this Batch solution? If yes, then concatenating would be easier for only the 'Batch' data model. As soon as you compound 0material all of BW needs to include the compound 0batch.

    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.