Interested to Buy Any Domain ? << Click Here >> for more details...
When is SID created? When is DIM ID created?
- 3 Answers
- 28482 Views
- Bosch, I also Faced
- E-Mail Answers
Answer Posted / asif khan
SID is surrogate ID generated by the system. The SID tables are created when we create a master data IO. In SAP BI Extended star schema, the distinction is made between two self contained areas: Info cube & Master data tables and connecting SID tables.
The master data doesn't reside in the Extended Star schema but resides in separate tables which are shared across all the star schemas in SAP BI.
An Unique Numeric ID , the SID is generated which connects the dimension tables of the infocube to that of the master data tables.
The dimension tables contain the DIM IDs and SIDs of a particular Characteristic Info Object. Using this SID Table the Master data ( attributes and texts of Info Object) is accessed.
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
If you are asked to change the way tables are displayed in web reporting how would you do this?
You want to convert bex query global structure to local structure. How would you do that?
What is the purpose of sap bw/bi?
Can you give a list of standard web items delivered?
What is a validity determining characteristic?
Explain business blueprint stage.
What are the monitor settings?
List the steps to do the converting from lis to lo extraction.
What is an infopackage?
What is the use dso in bw system? What kind of data is stored in dsos
What is the alpha check execution program?
What is infoobject otpauth?
What is 1 ROWCOUNT key figure?
iam looking for some scenarion on reporting concepts like - replacement path,customer exits, all types of variables. plese send me some important links and materials. so it will be helpful for me. thanks in advance
What is the library?
