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..
These would be "Ad-Hoc" reports and can be developed using the same Package(s) as the reports that were initially developed in DEV.
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..?
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.
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..)
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.
:)
No..I would not do it. Create the connections first, and then do the export. (don't check the connections option)