Transaction data

[Former Member]

Hi

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

0PROFIT_CTR_ATTR

0PROFIT_CTR_TEXT

0PROFIT_CTR_0106_HIER

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.

Regards

vijay

[Former Member]

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.

Regards,

-Ashish

[Former Member]

Hi,

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,

Eugene