Interested to Buy Any Domain ? << Click Here >> for more details...
When is SID created? When is DIM ID created?
- 3 Answers
- 28307 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 the importance of 0requid?
Define the upgrade steps to 3.x?
Explain bp master data?
How do you use the value set in bex query?
What is aggregate hierarchy?
How will you configure BW to load data from data stages?
What is 0record mode.
I have a process chain is running the infopackage get error don't process the error of that info package and then you can run the dependent variants is it possible?
What is the issued with V3 updates prior to PI 2002?
How do you convert from LIS to LO extraction?
We have standard info cubes given in sap why you created zinfo cubes can u tell me the business scenario
is their any difference between bex 3.5 and bex 7.0?
What is the use dso in bw system? What kind of data is stored in dsos
What is customization.
How do perform real-time data acquisition in a bw system?
