Skip to Content
Former Member
Dec 01, 2008 at 11:53 PM

SID generation during ODS activation


Hi All,

I need few clarification on the below items

1. What is the purpose of SID generation setting( Bex reporting) in ODS Setting. I mean what it will do while activating the ODS. Please explain in detail.

2. Will there be an impact on query performance if this setting is not selected for the ODS.

3. Consider the example below

Say there are 3 requestts already loaded to ODS with SID generation setting. Then I remove the setting. After that I loaded the 4th request without SID generation setting.Again I am seleting the SID generation setting for ODS and and loading the 5th request.

My question is that will this generate SID's for 4th request also.

Thanks in advance.