Showing results for 
Search instead for 
Did you mean: 

Transaction data

Former Member
0 Kudos


I have used the following extract structures for Profit center master data loading.




Once after completing the master data load then i need to extract Transaction data relating to the profit center.

If i extract and store it in an infocube how can i correlate the transaction data with the loaded master data.

Thanks for your support.



Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Sundarshan,

Master data and Transaction data will be connected automatically. You just see BW Schema, will clear you. basically,Fact table holds the Transaction data and Master data Tables (Text/Hier/Attr) holds the Master data and Master data table is connected with the SID Table and your SID and Dimension table are also connected together by DIM ID.

Also, you have the option of loading transaction data without having the Master data.

Hope this helps and clear your doubt.Please reward the points if the answer is helpfull to you.



Former Member
0 Kudos


You you uploaded master data first then during upload of transactional data the correlation between the MD and the cube content will be maintained automatically.

Best regards,