Skip to Content
author's profile photo
Former Member

Consolidating multiple datasource in a single datasource

Hi All,

I have a requirement to add a new characteristic field to BW. While analysing I found out that in R/3 system to get each characteristic value a separate datasource has been maintained. While I feel that a single datasource could have served the purpose. But I can't find any possible contact person who could justify the design. Can anyone please advice on the present scenario. All shall I go with the existing design and create a separate datasource or shall I try to consolidate all the datasources in a single datasource?

Thanks in advance,

Sananda

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Posted on May 02, 2011 at 10:39 AM

    You can append the characteristic in the datasource and write code in CMOD to populate the value.

    But can you give some more details? Like do you master data datasource here?

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      I second above.

      As it is master data, so SAP provides separate datasources for each. As the key is the Char value.

      if you put many masterdata tables in a view for single datasource, the records in the DS will not make sense.

      A B C

      A1 # #

      1. B1 #

      2. # C1

      In this process you do save using 2 datasources, but there is no else benefit of this. Making it unnecessarily complex and confusing for some other developers who see it later.

      If the tables are unrelated, it is not advisable to have them in a view.

  • author's profile photo
    Former Member
    Posted on May 02, 2011 at 01:38 PM

    Hi,

    It will depend on your requirements, scenario and where is the all the source data lying. The solutioning is possible using two datasources or a single datasources. If you have two datasources, if ur reporting requirement needs the output combined output. You can load two respective data targets and create a multiprovider or an infoset (again depending on your requirement) or create a DSO and load data from two datasources in one DSO and report on one DSO. Other way you can create a single Datasource and get all the data populated in single Datasource and load data in BI and generate output.

    Regards,

    Vikram.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on May 03, 2011 at 04:27 AM

    Hi Sananda,

    You can keep source as different datasource into one DSO as target with defined keys in DSO based on reqiurement.

    Regards,

    Avinash

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 06, 2011 at 10:49 AM

    Thanks for your suggestions

    Add comment
    10|10000 characters needed characters exceeded