Interested to Buy Any Domain ? << Click Here >> for more details...
When is SID created? When is DIM ID created?
- 3 Answers
- 28602 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
what is meant by safety upper limit and safety lower limit in all the deltas tell me one by one for time stamp, calender day and numberic pointer?
What is proposed from statistics for aggregates?
Can you name a few important tasks which are essential in the data warehousing and management of the same?
Define the steps necessary to set up CO-PA for BW?
List the tools to monitor overall query performance.
How do you access to source system data in bi without extraction?
Explain customization?
How to get the recordmode D or A in changelog table when we delete or add records in DSO?
How do you enter documents?
What is the dimension in bw?
Can you convert an infopackage group into a process chain?
What are the do?s and don?ts?
what is high cardinality tell me brief
What are the steps in general to enhance data?
What is customization.
