We've recently completed our preliminary 2009 financial plans and expense budgets, so we're in process of archiving the data from those applications. We had our Database Administrators set up new databases on our sql server (since we don't have rights to set up new databases) and had them copy/force restore from the current databases into the new ones. We set up the new applications in the Contributor Admin Console (linked to the new databases, adjusted the application display names), added them to the job server's monitored applications, and made sure the GTP Options specified a unique package name. For some reason though, the new applications are not showing up in the application list on the website. This is our first attempt in the Cognos 8 world (using Planning 8.3). Is there something I need to do in Cognos Connection to validate these new applications? Did I miss something somewhere?
Hi Rick
have you performed a GTP on the archive application having selected to created a new package in the GTP wizard options? This is essential the first time to add the app to Connection.
You might in addition think about changing the right to read only or by means of access tables, as the archive version should not be changed anymore.
Yes we GTPed the model. Likewise, we submit with a status of Lock to make it Read Only.
This is something I have done many times in the past but in the 7.x version of Planning. This is the first time for 8.3 so I did not know if there is something I am missing (e.g.: do I need to do something within the web side under Administer Cognos content?)
In contributor admin console, under application maintenance, visit 'Go To Production Options'.
1) Verify the box is checked to a publish a package.
2) Verify the package name. After the restore, the package name would still read the package name of the original application name despite the fact that you renamed the application during the import to CAC. If that is the case, the package online is now pointing to your restored database rather than your production application. To correct this, update the package name in CAC and then GTP both your production application and new (restored) application.
2) Verify the path in Cognos Connection that the package is publishing. Visit that location in Cognos Connection to see if the package is there.
3) Verify you user account has access to the application.
Thanks,
Steve
I thought the solution had to be simple ... and it was.
For Cognos 8, the box "Create Planning Package" needs to be checked the first time you GTP a model or the website will not recognize it. And, it is my understanding that this box does not need to be checked in later GTPs.
Thanks to all who provided help!
Quote from: RickC on 12 Dec 2008 04:56:52 PMAnd, it is my understanding that this box does not need to be checked in later GTPs.
It should be checked in later GTPs as well because this process adopts the Connection package security settings to possible changes be in the rights section of the Admin console.
By the way, the first release of version 8.2 will duplicate the Connections entries; this bug is covered in later available versions.