SID generation during ODS activation

[Former Member]

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.

Regards,

Fazil

[Former Member]

Hi,

1) The setting makes sure that all the records getting loaded to the DSO have there infoobject SID'S created while activation.i.e. each object values in each box of rows and column will be checked for SID's and if no SDI created then it will create for it in the respective SID table of the infoobject.

SAP tries to make sure that no reporting is done in case if any SID's are missing or not created properly for any info object...because in case of missing SID'S the value in the reports may be wrong and very slow and it will tough to trace the error.

2) If you do not check this setting then the queries may get hit badly as SID's may not be proper in many case and you may get bad results or very slow results...but still query is possible.

Since reporting is done through SID comparison..therefor for even small amount of data the query may take long time.

3)Yes it will.

When you check this option system will create SID's for all the data which is present in the table.

Thats is.... it will check and generate the SID's for records loaded in 1-4 request in the cube when you make the changes and activate the DSO.

This will happen while you during the activation process of the DSO after change...once DSO is activated all the SID's are created as well.

Then it will create SID'S for the new data loaded normally as usual while activation of the request.

Thanks

Ajeet

[yogesh8984]

Hi Fazil,

Here are the answers to your questions...

1. If you want to use the ODS/DSO for reporting purpose, you can tick this setting. This will create the SIDs in the backend which will help the processor to fetch the data from database while reporting.

2. Of course there will be an impact on query performance if you do not tick that option. In this case, SIDs will be generated at query runtime which will degrade the query performance.

3. No.

Hope this helps you.

Regards,

Yogesh