When is SID created? When is DIM ID created?
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
What is the licensing requirement you should be aware of?
What is the advantage of CO-PA?
What are the general services supported?
What is business content?
What is the dimension in bw?
what is high cardinality tell me brief
What are the versions in objects?
How the dimensions are optimized?
What is proposed from statistics for aggregates?
how would you re-assign to proper component?
What exactly do you know about the term data flow in the business intelligence or business warehouse?
How do I separate development from the production environment?
What is the use of db connection in sap bw data acquisition?
Why is one request falls, all the subsequent requests are turned to ?red? in an info provider?
What is infoobject catalog?