InfoSets - Need 1-N relation + 2 1-1relation

[Former Member]

Hi,

i am trying to make and infoset on which i will do reporting on my requirement are

Get all sales deal (With or without sales order) an report then using masterdata attributs on material and customer

Can this be achive with an infoset

the 1-1 relationship is use to get a navigationnal attribut

1 - N RelationShip = All SalesDeal(Infoobject)with SalesOrder(ODS)

1 - 1 RelationShip = for each salesOrder = 1 material(Infoobject)

1 - 1 relationShip = For earch SalesOrder = 1 Customer(Infoobject)

Rec 1

Sales Deal = 10001

sales order 200

customer A1

material B1

sales order 300

customer A1

material B1

Rec 2

Sales Deal = 10002

sales order #

customer #

material #

sales order #

customer #

material #

Thanks

[Former Member]

You can try InfoSet starting from the Sales Deal InfoObject and use Left outer join to the Sales Order. Material and Customer from sales order can be connected to the master data object using the Inner Joins.

Regards,

Sree

[Former Member]

hi , thanks for your quit respond, this is what is was doing but still BW is giving me the error message

forgot to mention that we are using BW 3.5 at the moment

Invalid On condition on the ODS ,

in order to have all salesdeal from masterdata i have to set the ODS to outer join this cause all other master data link to outer join thus giving me the error message

if y put the outer join on salesdeal i only see ODS data which is not what i want ......

first i drag the salesdeal infoobject

then the ODS

make the link on salesDeal , right click on the ODS and select outer join

then drag the 0customer and 0material info object.

and make the link with the ODS....

it works when linking the salesdeal and the ODS but as soon as i

add another infoobject the ON condition does not work

[Former Member]

It appears like there is a limitation on the Infosets when using Outer joins. No further objects can be connected to the object that is connected using Outer join.

Reference: http://help.sap.com/saphelp_nw04s/helpdata/en/ed/084e3ce0f9fe3fe10000000a114084/frameset.htm

Regards,

Sree