When is SID created? When is DIM ID created?
Answer Posted / sangeeta
SID is generated when you load master data.
Dim ID is generated when you load Transaction data.
In SAP BI Master data is loaded once and used across the system when needed.So to Share master data a SID table is created where it holds the id of each entry.This ID is generated by system when data is loaded to object called SID.
In this way you can access master data in multiple cubes.
Dim ID is generated when you load Transaction data to cube.
Dimension table holds SID & DIM ID-->master data and transaction data is connected.
A simple example:
MASTER DATA
cust_id name location
c101 Cris Hyderabad
c102 Kria Banglore
c103 Steve Delhi
When above data is loaded to info object an SID table is filled with SID's.
SID Table
MD SID
c101 11
c102 96
c103 24
TRANSACTION DATA
Cust_id Product_id Quantity Price Amount
c101 P23 5 5 25
c102 P27 8 100 800
c103 P35 4 25 100
When the above data is loaded to cube Dim id's are generated.
fact table will look like
CUST_Dimid PRODUCT_Dimid Quantity Price Amount
78 61 5 5 25
75 62 8 100 800
71 63 4 25 100
Dimension Table of customer will be:
CUST_Dimid Sid
78 11
75 96
71 94
In similar way Product Dimension Table is filled.Try to work out for Product by considering few products.
Is This Answer Correct ? | 33 Yes | 0 No |
Post New Answer View All Answers
Explain tickets?
What is the data flow from LIS tables to BW?
In real world when do you recommend aggregate?
How do you do Currency translation in SAP BW ?What are the settings that needs to be done?
what is meant by compounding attribute tell me the scenario?
What is a SID table and advantages?
What is infoobject catalog?
How do you use print settings?
How can I configure the workflow so that when the deadline is missed the workflow step is simply skipped?
what are the Info Cubes developed in a sap project? Name them and what is the requirement
where can we find transport return codes
What are the types of reports you can use in reporting agent?
What are processing commands?
How would you do the calling a bw query from an abap program.
What is the use of the info area in the sap bw system?