Arul's.TEG Blog

What permissions are required for the database account that is used by the Cognos content store? SQL Server - Grant create and drop table privileges for the database to the user account. - Ensure that the user account is a member of the db_ddladmin, db_datareader, and db_datawriter roles. - Ensure that the user is the owner of their default schema. Oracle - connect to the database. - create, alter, and drop tables, triggers, views, procedures, and sequences (all permissions must be granted directly to the user account rather than to a role). - insert, update, and delete data in the database tables Sybase - Grant create and drop table privileges on the database to the user account. - Ensure that the user account has the following privileges for the database: create default, create procedure, create rule, create table, and create view. DB/2 - Grant create and drop table privileges on the database to the user account. - Ensure that the user account has CREATETAB, CONNECT and IMPLICITSCHE

When executing a move... or copy-and-paste on a report, and overwriting a report of the same name, schedule information is removed and report view links are broken. Solution Starting in 10.2 this behavior changed. To revert back to the old behavior a switch was introduced in the system.xml for customers who want the old (update) behavior. Customers will have to explicitly enable it to get the old functionality if they so desire it.   To enable the old behavior, do the following:    1. Edit the /templates/ps/system.xml    2. Add true    3. Restart Cognos Server take effect