If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Deploy Framework Manager from Dev Production

Started by phanicrn, 20 Nov 2007 02:54:51 PM

Previous topic - Next topic

phanicrn

Hi

I would like to know, what should be considered when moving a framework manager model from dev to prod box.. In My situtation, We want to do live Reporting on Daily Data.

Here is my scenario. We have developed cognos FM in dev box with SQl2005  and we have created some sample reports & tested data, Everything is working fine.

Dev enviornment.
-----------------
Cognos  installed on cognos-dev box
sql server  installed on sqlserver-dev box,database name in sqlserver is  "edwtest"



Production box
----------------
cognos installed on cognos-prod server
sqlserver installed on sql-prod server, Database name in prod will be EDWProd.

In Other Scenarios' We do import & export of  package which has reports developed from dev and export to production, that's the usual process everyone follows..

But we want build live report from production system do i have to move the fm model which was developed in dev box and open the model in prod box and publish the package. because users will be creating  live reports on daily basis.

what r steps i should considered..


rockytopmark

These would be "Ad-Hoc" reports and can be developed using the same Package(s) as the reports that were initially developed in DEV.


phanicrn

so do i have to  copy the fm model from dev box and create new datasource in prod box, prod datasource would be pointing to sql prod box and open the .cpf file and publish the package..

is that what u r saying..?

rockytopmark

Best Practice:

Develop and publish packages in DEV

Migrate Packages from DEV to PROD via deployment.

DataSource in DEV points to Dev db, and DataSource in PROD, with same name, points to PROD db

No publishing directly to PROD should be needed.

Cng2005

You can make SQL Server aliases. Assign the same alias to PROD and DEV servers, however internally in Cognos connection, point to the respective databases. In that way, you dont have to worry of connection when you move reports from DEV to PROD...(at least 1 less thing to worry about..)


phanicrn

Small Question,

When doing export of package from Dev to prod, From the Export option, do i have to select the datasource connection from the export wizard.

:)

Cng2005

No..I would not do it. Create the connections first, and then do the export. (don't check the connections option)