Skip to Content
0
May 16, 2013 at 01:02 PM

Fact table SID's not matching with Dimension table entries.

37 Views

In a cube some data is not reflecting in the report . So when we did list cube by strange we can see data only if we select SID of char "0version". Else if we select only Version no data is populating.

So I saw that the Fact table key (DMID) (/BIC/F******) for 0Version is 19 and this is not there in Dimension table (/BIC/D******) of 0version. And further not there even in S table of the 0version.

Also there is no mannual load to 0verison, S is being populated as part of transactional load. But only Text is vai flat file.

So I am not sure if this SIDs are deleted as part of any Master data deletion. And how can we fix the issue. Is it we can only fix by reload only.....its a SNAP data so i dont have option of reload.

Can anyone suggest if you faced the same situation. As because of this only data is being populated are, those having related data of fact table in Dimension ID table.