report referenced structure

[Former Member]

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.

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Roberto,

You have understood correctly.

What does it mean - "create an unique record" for ODS object ?

thanks very much

Fiodar

[Former Member · Accepted solution]

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