Discrepancies between fact table size and an aggregate function outcom

[vtd]

Hi All,

here is the issue I'm encountering:

I created a cube that used to display good values.

However, there has been discrepancies for two weeks when I use MOLAP storage to store my cube (I don't come by the same outcomes when I use HOLAP storage).

Indeed, one of my cube's measures returns a greater value than the fact table size while this measure is the sum of a column values which are set to 1 or null.

I actually made a full processing of the cube and don't know how I can come by such values.

Can anyone help me ?

 

[Prasad678]

Hi,

r u using Cognos cubes?



Prasad
RPrasad1@Chn.Cognizant.com

 

[vtd]

I eventually found the solution of my issue: some primary keys of a dimension table were duplicated what accounts for they were counted several times.

I know that this table shouldn't have allowed duplicated 'primary keys' but its designer has gone far away.

 

[IMAGINAX]

Is that *because* they allowed duplicate primary keys?



Mike