Skip to Content
0
Former Member
Apr 29, 2014 at 12:41 PM

DSO with flag "SIDs Generation upon Activation" deactivated

91 Views

Situation 1:


I am using a standard DSO. The flag "SIDs Generation upon Activation" is not set. Note 1392715 states:

"... If you deactivate this flag, reporting is still possible since missing SIDS will be created during the query runtime from 7.0..."

Question 1:

What is about characterstic values with already existing SIDS? Are they selected at query runtime? Are SIDS created during query runtime for all characteristic values, even if the characteristic value has got a physical SID in its master table? Gets a query on this DSO faster, when pyhsical SID will exist in the respect master tables?

Situation 2:

I am using an infoobject with flag "attribute only" in a standard DSO. The flag "SIDs Generation upon Activation" is not set in this DSO. This DSO is connected to a virtual virtual provider based on DTP. The query Q1 on the virtual provider reports the infobject with the flag "attribute only". The query Q2 on the DSO doe not report the infoobject with the flag "attribute only".

Question 2:

What is faster? A query on a virtual provider or a query on a DSO with flag "SID Generation upon Activation" is not set.