Hi,
In real life scenario howmany models do we create normally in a project (nor FM project) and is there any restrictions on number of datasources and query subjects we can import into a model.
Thanks
Kris
I think - and that's just my humble opinion - that the most crucial limitation, in real life, is the computing power you have at your disposal. A stand-alone Cognos installation with all the data sources on the same server on a 2gb ram 5 years old machine will be running very slow with a plentitude of highly-complex models combining mutiple data sources all working together. Maybe even without. A distributed installation on shiny new strong machines with data sources finely tuned on their own strong machines will be able to do all that and more easily enough. Most companies are somewhere in between.
How many packages? As many as you need and your content store and machinery can handle.
There is no limitation on how many datasoruces or Query Subjects or Models you can create within one FM Project. However, I agree with NimrodA regarding creating one massive model where your query subjects join all kind of data soruces together.
That being said, it is perfectly viable to have many data sources and modesl in one project if you are using them within limits. Meaning -
Let's say you have 4 different FM projects pointing to different servers/databases etc using different data sources. It does not hurt to merge all of that in one FM project. You will still be publishing as many packages as you published when you had 4 projects. Just that you now have only one Project to maintain and your models within the same project are still seperate with each other using it's own data source/s. It is perfectly fine to use multiple data sources for the same model. However Cognos typically works slow when you join multiple schemas so if you have query subjects using 2 data sources each one of which is pointed to a different schemas, you are likely to run into performance issues even if you use the same Content Manager datasource connection.
Thank you all for your response.
Kris