Create Package Automated

[Fleschgordon]

Hi Cognos Profs.

I want to create a package for a ms sql database programmatically.
I want all views of the database in the package.
Is it possible to automate the whole process (generate and deploy of the package)?

Any tipps and guidance are very welcome

thank you
Fleschgordon

[bdbits]

Maybe with the SDK, though I have my doubts about how much can be done by machine alone.

But why? What are you trying to accomplish? If your only reason to use Cognos is for the reporting tools with no intelligence in the model, it is probably overkill for your requirements.

[Fleschgordon]

we use cognos as a enterprise reporting tool.

we have different customers with different needs - severel customers only want to query datatable and for that we want it.

[cassianobard]

I have the same interest.

Automate the development of FM, generating the XML files.

Fleschgordon, do you obtain any success?

[MFGF]

I have the same interest.

Automate the development of FM, generating the XML files.

Fleschgordon, do you obtain any success?

If you have databases with matching schemas, you could model the tables once in FM then copy the transaction log files and replay them on subsequent models for the different schemas.

Just a thought.

MF.