Arul's.TEG Blog

Here is what I did. cast(cast([calc_column]*100,integer), decimal(19,2))/100

In The IBM Cognos Business Intelligence version 10.2.2, -  encryptkeypair and signkeypair folder doesn't exist. Answer : These folders have been replaced by a single folder that is named certs . Some topics in the IBM Cognos Business Intelligence documentation make reference to the encryptkeypair and signkeypair folders.

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

Unable to install Cognos Consolidation on a server or workstation. When you start the installation it is aborted and gives you the following error message. Error Message - Setup cannot continue because of an outstanding reboot. Resolving the problem Delete the gsuninstall.flg file located in the user's temp directory. Steps - 1. Find the user's environment variables for TEMP and TMP. 2. Using Windows Explorer, navigate to the Temp directory. 3. Find the gsuninstall.flg file and delete the file. You can now install without rebooting.

IBM Cognos Theme Designer can be used to easily create custom styles for several tools in the IBM Cognos 10.2.1 product suite. Download Description The available zip file contains the tool itself, as well as a getting started document that provides detailed instructions on how to use IBM Cognos Theme Designer to create a new style. The styles produced by this tool are respected by the following products within the IBM Cognos 10.2.1 product suite: Cognos Connection Cognos Administration Cognos Search Cognos Viewer Event Studio Partial support also exists for Cognos Workspace; however, upgrade of the Cognos Workspace themes will not be supported in the next release. Prerequisites IBM Cognos 10.2.1 BI Server has to be installed. Installation Instructions Download and open the attached zip file. The zip file contains two folders: vers and webcontent. Copy these folders to the root of your IBM Cognos 10.2.1 gateway installation. Ensure your IBM Cog