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.