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,