COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: ghazalizahid on 17 Dec 2007 06:13:02 AM

Title: Limitation of 2GB File Size in Cube Creation
Post by: ghazalizahid on 17 Dec 2007 06:13:02 AM
I have a problem with the Cube Creation of limitation of 2GB File Size.

1. I have 60M Records and around 35 Dimensions.
2. The Flat Ascii file is used for the Cube Papulation.
3. trnsfrm.ini ( MultiFileCubeThreshold=1000000 ) for the Mdp Files

How can i avoid my cube from the above message.

Thanx
Title: Re: Limitation of 2GB File Size in Cube Creation
Post by: ykud on 17 Dec 2007 08:42:59 AM
Set MultiFileCubeTreshold in trn.ini (for 8.2 or previous) or in cogtr.xml  if you have 8.3.
Title: Re: Limitation of 2GB File Size in Cube Creation
Post by: billylodz on 01 Feb 2008 02:10:47 PM
It's bug in TR, the best solution is to Created Grop Cube on fex. on Time Dim
will be faster and with no problem when the data grows.