COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: Fleschgordon on 24 Feb 2015 01:02:54 AM

Title: Create Package Automated
Post by: Fleschgordon on 24 Feb 2015 01:02:54 AM
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
Title: Re: Create Package Automated
Post by: bdbits on 24 Feb 2015 09:42:58 AM
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.
Title: Re: Create Package Automated
Post by: Fleschgordon on 24 Feb 2015 09:48:34 AM
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.
Title: Re: Create Package Automated
Post by: cassianobard on 09 Jun 2015 07:51:29 AM
I have the same interest.

Automate the development of FM, generating the XML files.

Fleschgordon, do you obtain any success?
Title: Re: Create Package Automated
Post by: MFGF on 09 Jun 2015 09:06:34 AM
Quote from: cassianobard on 09 Jun 2015 07:51:29 AM
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.