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

report referenced structure

Hi,

I am beginner in BW, and I have troubles to build BW report.

I'v created two infosources with UD connect data sources. For each infosource one transfer structure is mapped - struct1 and struct2. Logically these structures have the common reference characteristic "key" i.e. row of the struct1 referenced by row of the struct2.

I couldn't find appropriate way how to setup provider, and represent report referenced data.

Thanks for any ideas in advance ...

Fiodar.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 05, 2005 at 11:05 AM

    Sorry Fiodar,

    I'm not exactly understanding what's your requirement...

    do you need to link records belonging to the first infosource/flow to the records belonging to the second one by using a reference field ?

    If yes, build an ODS in which you can create a unique record that has got what do you want thanks to the key combination...

    Let me know...

    Bye,

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Fiodar,

      create an ODS that will be the destination of both flows.

      ODS is a transparent table in which you have to define a key (an infobject/field set) and a set of data field.

      If you choose to put in the key all the infobjects that allows to identify only ONE record (e.g. the document number 0DOC_NUM if you are loading header documents: there will be only one document with that header number!) related to first flow, you can feed the ODS with the second flow by mapping in the update rules for the key fields with your reference field (e.g. you will map 0DOC_NUM with 0DOC_REF coming from the second flow)...

      in this way, you will have a unique record that contains all the info coming from both flows !

      Pay attention to the update method (summation(overwrite) to use for your data field if these are common to both flows...

      Hope it helps (and please don't forget to reward the answers by clickin'on the yellow star...for details see /people/mark.finnern/blog/2004/08/10/spread-the-love ...)

      Bye,

      Roberto

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.