Interested to Buy Any Domain ? << Click Here >> for more details...
When is SID created? When is DIM ID created?
- 3 Answers
- 28605 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
How will you get more details on data source and delta modes?
When you define aggregates, what are the available options?
Which report can you use to monitor change run?
How will you change the default destination of open hub files?
How do you do EURO conversion at the database level?
we have a ods in process chain and the ods activation is taking long time how will u optimize the activation process.
Give some examples of old LIS and new equivalent LO?
What are intervals?
Can you explain about start routines how you used in your project give me an example?
What is compression in the data warehouse?
How we do the sd and mm configuration for bw?
When we use condition the totals do not match why?
what are the benefits of cubes?
What is the importance of 0requid?
Explain 0record mode?
