Skip to Content
author's profile photo
Former Member

Error during ODS Activation

Hi,

While loading data into ODS, sometimes it gives an SID not found error. But the ODS is a flat stucture and does not have any link to the master data as in case of the infocubes.

Can any body explain why it happens like that.

And what is the techinal linkage between the master data SID and the objects used in ODS.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • author's profile photo
    Former Member
    Aug 13, 2004 at 02:57 PM

    Hi Karunakar,

    Check the sid table of the InfoObject. It might be that the sid and master data table are out of synch. If they are, then you need to re-build your sid table to synch them back up.

    Cheers!

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Aug 16, 2004 at 11:48 AM

    Check the ODS settings:

    If the ODS is enabled for BEx reporting then SIDs are checked during the activation process. Where as if the ODS is not enabled for BEx reporting the SIDs are not checked...

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks,

      I thing you got my point. I know that the SID are cheked if the ODS is set for BEx reporting.

      Can you tell me the table where it keeps the relation between the data in the ODS and SID.

      For ex. in infocubes we have the dimension table.

      In ODS also I heared that a table is there which keeps the relation. Can you tell me that.

  • author's profile photo
    Former Member
    Aug 17, 2004 at 09:13 AM

    Hi Karunakar,

    if you want to more deeply understand the relationship among ODS data and SIDs (in the activation process)I suggest you to directly take a look in the generated write program; you can find it (for every single ODS) in the RSDODSOLOC table (remember that in SE38 you have to add 'GP' to the program name found).

    Hope this helps,

    bye,

    Roberto

    Add comment
    10|10000 characters needed characters exceeded