Can we load Transaction data without loading Master data, explain w.r.tSID

[Former Member]

Can we load Transaction data without loading Master data, if so can you explain me how and when Surrogate Ids/ Dimension Ids gets generated.

[Former Member · Accepted solution]

<b>Can we load Transaction data without loading Master data</b>

Yes.

how and when Surrogate Ids/ Dimension Ids gets generated.

When u load Transaction Data SIDs will be generated which is not recommended as it takes time but when u have master data loaded then as the SIDs are already created TD loading will be faster !!!

[Former Member]

If you are not going to do reporting with your transaction data then you need not create the SIDs. For example if you are loading ur transaction data into ODS and from the ODS if you are updating the cube then for the ODS the SIDs need not be generated as it works as an intermediate detailed data storage.

Regs

Gopi

Assign points if it is useful.

[Former Member]

Thanks a lot for Your valuable answer

[Former Member]

Hi Gopi,

Thanks a lot

Points alloted

[Former Member]

Hi,

We can load the transaction data without loading master data.

But for loading performance issues it is recommended not to load the transaction data first.

Every infoobject in the BW is identified by SID, that means which we are loading the transaction data, considering a scenario for an infocube, the system will identify the infoobject by existing sid against that infoobject in the bw and correspondingly create DIM id's.

Now consider the secnario where master data is not loaded and transaction data is being loaded.

Now the system should have sid to identify and infoobject and to create DIM id ( which is the combination of sid's of the characterisc in it)

And as the sid's are not yet created i mean as there is no referece for the master data, the system will first create the sid for that infoobject it means it will create a copy of the master data in that infoobject nd then create the dim ids based on it and then load the data.

Here the additional task of creating sids are also being done during loading the transaction data which hinders the loading performance

I hope this is clear5 now

Janardhan Kumar

[Former Member]

Hi Janardhan,

Thanks a lot

[Former Member]

You can load transaction data without loading the master data, nothing technically wrong with that, unless you are doing some master data lookup in yout rules.

If you do load Transactional data without loading the master data, then yes, the master data attributes of the InfoObjects would be blank.

[Former Member]

HI Ali,

Yes u can load transaction data without master data.

[Former Member]

Ali,

Yes, you can load transaction data without loading Master data.Assuming that you are using BI 7.0.

1. If you are using an infopackage - In the update tab, The radio button - "Always update data, even if no master data exists for the data" ensures that the master data SID's are created if they don't exist.

2. If you are using DTP - You have more options to control it. You can use error DTP to handle these special records. For more information check the help link

http://help.sap.com/saphelp_nw70/helpdata/en/42/fa50e40f501a77e10000000a422035/frameset.htm

-Saket