Different SID in master data and in Cube

[former_member494935]

Hi Guru's,

Recently I am encountering a very strange issue.

I have a report which is having Profit_Ctr and its attributes. When I am trying to run the report and dragging one of the attributes, it is going into ABAP debugging mode and giving below error.

SID 99 for characteristic AAA_BBB could not be converted CL_RSDM_READ_MASTER_DATA->_SIDVAL_DIRECT_READ2

SAPLRRMS >> Row: Inc: 87 Prog: LRRMSU13

We are using Amount_YTD as key figure in our query.

• Steps which I have tried:

RSRV check - All checks are green

Ran RSDMD_SID_P_Q_REPAIR, RSDMD_CHECKPRG_ALL reports as well.

Everything is in green and no issues found.

• Findings:

One of the value of AAA_BBB attribute is having different SID value in Cube and Master data.

In cube it is showing 99 while in MD SID table it is 129.

Does anyone encountered similar issue? Is it possible to sync the SID table of Cube with MD SID table?

Kindly provide your expert opinions.

Note:

We recently have a system refresh

[former_member183012]

ok..Can you please run following test for your problematic characteristic.I am thinking your issue will be resolved by RSRV only.

[FCI]

Hi Sumadhur,

What do you mean by attribute ? Cube tables only contain SID values for the characteristics of the cube. SID for navigation attributes are only present in the MD tables.

The only "cubes" that contain SID for attributes are aggregates. If this is your case just fully rebuild the aggregate.

Regards,

Frederic

[former_member494935]

Hi Ganesh,

Thanks for the prompt reply.

I have already tried RSRV. I have performed below test in RSRV-

1. Check master data for characteristic

2. Values available in the navigation attributes

3. Foreign key relationship between dimension and SID table

It seems that the SID value of attribute which is present in Cube is wrong. As system is recently refreshed with Production system data and when I compared SID values of individual object in both system, I could see cube is having wrong SID value.

Please find below details regarding SID value of object AAA_BBB

Production System UAT system (recently refreshed with Prod system)

in Cube -> AAA_BBB (SID- 120) in Cube -> AAA_BBB (SID- 99)

in MD -> AAA_BBB (SID- 120) in MD -> AAA_BBB (SID- 120)

Thanks.

[former_member183012]

Hi Sumadhur,

I think RSRV should correct this error.what test you performed?can you please execute masterdata and others also.

Regards,

Ganesh Bothe