COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: snadgir30 on 15 Jul 2008 12:20:58 AM

Title: Custom specifying trnsfrmr.ini file to build multipartationed cube
Post by: snadgir30 on 15 Jul 2008 12:20:58 AM
Hi CognosGurus,
we have different servers - Server A for Cube building & Server B as reporting server.Such structurre exists across D,Q,P enviornment.Cube bulding on server A ,trnasfering it to reporting server & cube swaping on reporting server is automated batch process.

Now the doubt/question is -
we have one of the application having cube size more than 2 GB.for this application we are modifying trnsfrmr.ini so that partitioned cube is built.

is there anyway that for this particular application only this trnsfrmr.ini is refered?

in other words we dont want rest of  the applications to use this pecular trnsfrmr.ini setting (which is modified for multipartitioned cube built)for their cube build.

I hope i manged to put my doubt in simple words.
;D

Regards
snadgir30
Title: Re: Custom specifying trnsfrmr.ini file to build multipartationed cube
Post by: Ty Clabbers on 15 Jul 2008 03:00:23 AM
For almost every parameter you can alter in the trnsfrmf.ini file is a commandline option. This one is "-dMultiFileCubeThreshold=XXXXX". You can also specify an alternate ini file just for one cube build on the commandline.
Look at the "step-by-step tranformer" (pp_sbs_trns.pdf) help document. One  of the appendixes covers this.