Skip to Content
0
Former Member
Dec 09, 2008 at 08:27 AM

Duplicate Entries in Fact Table for same combination of DIMID's

331 Views

Hi Experts,

I am facing a very very peculiar issue.

When I am trying to see the contents of the fact table for a particular cube, I can see multiple entries in it for the same combination of dimids with different values for the key figures.

I think it should not be the case as I am under the impression there should be a single entry only for each unique combination of dimids in the fact table.

Upon testing, all the RSRV tests are coming as green.

The database is Oracle and we are on BI 7.0.

Could you please help me out is there are settings involved anywhere or any parameters need to be changed. The cube is 0CCA_C11.

Thanks in advance.