Error activating data in ODS with two datasources - SID issue

[charla_robertson]

Hi All,

We have an ODS that updates a cube. For the ODS called ZRT_O35D, there are two sets of update rules. One set is from the 2lis_03_bf datasource, the other set are from itself (ie: 8ZRT_O35D). The ODS gets updated with BF, then with 8ZRT_O35D. The 8ZRT_O35D set of update rules updates both the ODS and the cube directly. Then after this occurs, the BF request, and the 8ZRT_O35D are pushed to the cube. This does not result in duplicate data because we are using the 8ZRT_O35D to obtain some charateristics only, no updates for key figures.

My issue is when I update, I cannot activate the requests in the ODS because its telling me the SID is smaller than what's in the cube already.

For example, the requests in my ODS are:

138300 2LIS_03_BF TR DELTA

138299 Delta for Update by ODS ZRT_O35D w/PSA

Requests in my cube are:

138299 Delta for Update by ODS ZRT_O35D w/PSA

138281 Delta Package for Update by ODS ZRT_O35D

When I try to activate 138299 I get the message:

Request REQU_4E5GY88YDBT19W1UXXYGWGNKE (138,281) for DataSource 8ZRT_O35D from source system WWQ100 has the status (green) and a smaller SID (is thus older) than the request that you currently want to update into the ODS object.

I tried changing the design a bit so that the 8ZRT_O35D update rules update the ODS only, not the cube. Then BF would be loaded. Then both requests activated and pushed to the cube. This didn't work either. I was getting the same SID issue.

Note, we are on version 3.5.

Any suggestions?

Thanks

Charla

[neelesh_jain3]

Is the request number "REQU_4E5GY88YDBT19W1UXXYGWGNKE (138,281)" same when you get the error message. If thats the case go to T.Code RSRQ give this reuqest and change the reuqest status to red and then try activating the ODS.

Cheers,

Neel.

[Former Member]

Hi Charla,

Have you tried the following ?

1) Load ZRT_O35D with 8ZRT_O35D

2) Activate the above request

3) Load ZRT_O35D with 2lis_03_bf

4)Activate the above request

5) Now Load the Cube

Dorothy.