Skip to Content
0
Former Member
Jan 04, 2008 at 10:18 PM

Transaction Data Linking to Master data Infoobject

34 Views

Hello,

I am trying to create a InfoCube

In My cube Transaction data Infoobjects as follows and I am loading this data via CSV file

1.Order No

2.Order Type

3.ExtPrice

4.ExtCost

I need to link My Master Data InfoObjects with Transaction Data in Data Source

1. Order Header(Keys:Order No(XORDNO),Order Type(XORDTYP)

2. Order Detail(Keys: Order No(YORDNO),Order Type(YORDTYP)

How can I link with One Transaction Infoobject with 2 Master Data Keys

I mean to say how to connect above 2 Master Data Infoobjects using my transaction data?

I can able to connect Order Header Infoobject using XORDNO,XORDTYP in my Data Source

I am unable to connect Order Detail Infoobject because there is no transaction data exist

Let Me provide sample Transaction Data record

Example

Record1: ORDER01,ORDTYP1,$100,$200

Record2: ORDER02,ORDTYP2,$250,450

In my Data Source I can link ORDER01,ORDTYP1 with Order Header infoobjects(XORDNO, XORDTYP)

My question is how to get Order Detail Master Data?

I will assign the full points for correct answer

Thanks,