Hi
I have a problem where I have identical non value records which are not rolling up (sum) in the cube.
I have tried the Duplicates roll up to sum, set time state properties to day (as datasources go down to day but are only reported at month level). I have also set consolidate in the cube properties to Yes but all are still excluding duplicate records.
Any other ideas? Would including Day in the model and then Suppressing it work?
Out of ideas,...... :'(
its been six months since I looked at transformer, last version 7.3 built some huge > 5.5gb cubes in a unix enviornment, slowly regaining interest ... bare with me....check your datasource ie copy paste to toad and interigate the data feeding the cube.. sql from imr, iqd or sql via transformer... somewhere the record is not unique