Interested to Buy Any Domain ? << Click Here >> for more details...
When is SID created? When is DIM ID created?
- 3 Answers
- 28483 Views
- Bosch, I also Faced
- E-Mail Answers
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
What are the versions in objects?
Apart from r/3, which legacy db you used for extraction ?
What are the steps to do the extractig data from r/3.
What is an infocube?
Explain business blueprint stage. What do you do here?
Please tell what are the tables we can use in FISL and COPA in real time.. Explain clearly?
What are the tools to monitor overall query performance.
What is automatic loading of similar/identical requests option?
What are the template options?
What is the precaution you should take when archiving?
What are the hierarchy relevant parameters?
What are the general restrictions?
What are the proposal options available?
what are the reports used from business content in sap bw project?name them and what was the requirement?
Explain about the dimension in the warehouse?
