How to change SID values in SID table ?

[Former Member]

Hello Experts,

we want to change the SID-values of 0FISCYEAR.

Reason: data, that has been loade for e.g. 2010 is to be displayed as 2011 and so on.

That means, we want to give the entry of 0FISCYEAR for 2010 the SID for 2011 and so on.

(I know there are other possibilities, but we want do to it that way).

Now we found two possibilities for changing the SID (by switching to debugging ( /h ) mode in the display of the SID table):

1) change the SID to a value that has not been assigned yet (to not interfer with the unique index on the SID) and later change it back to the desired value

2) deactivate the unique index on the sid in TAC e.g. SE14 (and later activate it again) and change values

But both methods lead to errors in reporting. Messages are like "SID with value xxx cannot be found" (even though it´s there according to the SID-Table-Entries). So the reporting (queries) don´t work any more after changing the SIDs, even though the values in the dimension tables of the cubes haven´t changed.

Does anyone know the reason for this ? Or even better, has anyone a solution how to change SIDs so that afterwards the reporting still works ?

Thanks in advance,

Frank

[Former Member]

SIDs are system generated values which you can not replicate... it is advisable to reload 2009 data as 2010, 2011 and so on...

you can make a self load on the data target!

[Former Member]

Thanks for the advice, but I explicitly wrote "I know there are other possibilities, but we want do to it that way". We want to change the SID-values, and that is my question, is this possible and how.

[Former Member]

system generated value might be referenced at different places and it might be stored at several locations.

if you change one value you risk mismatch with other references...

so it is not possible to change SID values amanually and expect to run smoothly...