.PY? versus .MDL files
.PY? versus .MDL files
(OP)
In Powerplay, I know you can save a model as either a .PY? or .MDL file. And I know that the .MDL version is ASCII that can be used for automating Transformer and can also be used to transfer cube models between versions of Transformer.
So, the question. Other than what I listed above, is there any operational advantage to using .MDL files vs. PY? files? Faster builds? Smaller cube file sizes?
Thanks.
So, the question. Other than what I listed above, is there any operational advantage to using .MDL files vs. PY? files? Faster builds? Smaller cube file sizes?
Thanks.
RE: .PY? versus .MDL files
As the .PYI stores security, the model can be run in batch, otherwise the model would prompt for the password to the database and would be waiting it.
That's all. Hope this helps
Einyel
Functional&Technical Cognos Consultant
RE: .PY? versus .MDL files
Bruce
RE: .PY? versus .MDL files
Mdl's are smaller as they contain JUST the information required to build the cube. They are also the 'supported' way to upgrade from version to version as they are portable.
Pyi's can grow to be quite large as they are binary files and can become 'unfragmented' and tehy tend to store a lot of legacy information that you can no longer access. The upside to these is that they can store signon information and will run SLIGHTLY faster.
flex
RE: .PY? versus .MDL files
When your model is developed using PYx, before using it in test or production, save it as a MDL file. Then open the MDL and save it back to PYx , it remove the fragments and the PYx size decrease.
RE: .PY? versus .MDL files
PYIs can fragment but have the ability to store signon information and run slightly faster runtime than MDLs. Fragmentation can be reversed by saving to MDL and then resaving as a PYIs.
MDLs are slightly smaller, slightly slower, don't fragment, can't store signon information but can be used when upgrading cube models from one version to another.
Thanks again. Maybe we need a poll of how many people use either PYI or MDLs regularly as their main storage format. :)
RE: .PY? versus .MDL files
MDL's - Main
PYI's - Storage/backup
CP
RE: .PY? versus .MDL files
Another plus of MDL is that you can read the file directly in a text editor. I had to use PYx to use sign-ons & run unattended cube updates.
Bruce
RE: .PY? versus .MDL files
I use PYx for the regular builds, and then a save to MDL and then back to PYx to 'compress' large models that have levels which grow over time (document numbers).
With the signons, it also allows other (trusted) users to kick off cube builds when you're not around/available.
lex
RE: .PY? versus .MDL files
flex
RE: .PY? versus .MDL files
RE: .PY? versus .MDL files
With the data on the lowest level removed, the mdl was a svelte 6MB.
Had I just had a copy of the pyi, chances are I'd have had to create the model again from scratch.
lex
RE: .PY? versus .MDL files
Bruce