Interested to Buy Any Domain ? << Click Here >> for more details...
When is SID created? When is DIM ID created?
- 3 Answers
- 28308 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 is direct schedule and what is meta chain
How can you navigate to see the error idocs?
What is sap bw/bi? What is the purpose of sap bw/bi?
What is Infoset Query?
How do you convert web objects from 2.x to 3.x?
What is a temporal join?
We have standard info cubes given in sap why you created zinfo cubes can u tell me the business scenario
Give some examples of old LIS and new equivalent LO?
What is the difference between sap bw 3.0b and sap bw 3.1c, 3.5?
Extraction in mm and SD and FI? What is the requirement and name them?
Which of the tables are inside and outside cube in an extended star schema?
What are the pre-requisites of DB connect?
How do start routine and return table synchronize with each other?
What is the number of decimal places in scaling factor?
How would you measure the size of a infocube?
