Question:
Hello,
What is the significance of SID (Surrogate ID) in BW. Will someone throw some light.
Thank u
WILSON
Answer:
I had a nice cup of tasty coffee right now, so I will try to answer, but generally speaking this question is a little bit wide to be answered here..
Without going into too much detail as we don't know anything about your level of knowledge/understanding of the BW start schema,
let's say a SID is the code that make the link between the master data and the transaction data.
In the fact table, you don't store
CHARACTERISTIC...KEY FIGURE
BLACK PRINTER.......1
YELLOW PRINTER.....2
you store
5410.......1
5411.......2
and then in another (master data) table, you store
5410...BLACK PRINTER
5411...YELLOW PRINTER
the codes 5410 and 5411 and the so-called SID.
!!!!! THIS IS A LIMITED AND UNCOMPLETE EXPLANATION !!!!!
I voluntarily skipped some notions like DIMID and other stuff;
so this explanation is not technically 100% accurate (even not 50%),
but the aim is that you understand the concept of SID,
then you'll understand the rest by reading some documentation.
'hope this helps
Ch