COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: mewyeen on 07 Sep 2008 10:37:18 PM

Title: Transformer Model (PYI) file size
Post by: mewyeen on 07 Sep 2008 10:37:18 PM
I have a Cognos transformer model (compiled) which the file size is around 300KB.  After I compute to generate the power cube, I notice that the file size is increasing become around 12000KB without any modification.  Is this the normal in the file size?
Title: Re: Transformer Model (PYI) file size
Post by: Ty Clabbers on 08 Sep 2008 04:45:31 AM
Powerplay adds all the categories to the model when building the cubes. You then can either save the new model (with all the categories and thus larger) or discard the changed model.
You can always use the clean house option to remove the categories not used since a choosen data or you need to remove all the categories by hand.
Also saving a model as a mdl, restart powerplay, open the model and save it a pyi will sometimes result in smaller model file (don't ask me why).
Title: Re: Transformer Model (PYI) file size
Post by: mewyeen on 08 Sep 2008 09:42:32 PM
Schleppel, Thank you very much.