If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Records not rolling up correctly in Transformer

Started by HWC, 04 Oct 2007 11:55:14 PM

Previous topic - Next topic

HWC

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,...... :'(

Cannondale23

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