Question:
Manual says
----
If the indicator is switched off then no SIDs for the new characteristic values have to be taken when activating the data in the ODS object. This improves the performance of the activation.
Switch off this indicator for all ODS objects that are essentially used for further processing into other ODS objects or InfoCubes. It is still possible to define InfoSets with the ODS object and to carry out queries on it.
----
Means that in the ODS table are the real values stored and not the SIDs from the master data tables of the info objects.
When switching on the BEx reporting. The SIDs are stored and during loading processes it is checked whether this new characteristic is already included in the master table and if not a new entry including new SID is generated and used in the ODS table.
Or I am totally wrong.
Would be great if a guru clear up my mind. Thanks in advance.
Answer:
I am not a Guru but this is how I interpret it and your description is very close to how I understood it .
I don;t think ODS tables store SID's but during activation from the new to the active table it validates the characteristics values in the ODS against the master data tables to make sure there is a SID available for the values being loaded in the active table. If not value is found then a SID is generated in the master data table provided you have set the flag for master data in the IMG.
So if a ODS is not required for reporting activation would run much faster by bypassing the step for validation against MD tables.
I would welcome other expert opinions on this as this is a good posting from Garp .
ST
Answer:
I don;t think ODS tables store SID's but during activation from the new to the active table it validates the characteristics values in the ODS against the master data tables to make sure there is a SID available for the values being loaded in the active table
Sounds logical to me: but just 1 question : WHY?
Let me clarify: if the ODS table doesn't contain SIDs and reporting is done against the active table of the ODS, why would he create SID's in the first place? Is it for the navigational attributes in the ODS??
Tnx for enlightening me...
T.