Submitted by Rhonda Jeshi
The aim of the IBM AuditDBCleanup tool is to provide customers with easy cleanup capabilities of their IBM Cognos audit logging database, allowing old database records to be deleted regularly based on a timestamp.
Benefits
Supported databases are all the conformance audit logging databases: DB2, Informix, Oracle, SQL Server, and Sybase.
Can be used on Windows and UNIX in two ways: via User Interface or via command line.
Takes full advantage of the... [Continue Reading]

Submitted by Raj Kumar Thippani, Tata Consultancy Services Limited
This technique covers how to to migrate/switch the Impromptu Query Definition (IQD) to Package Data Source in IBM Cognos Transformer without impacting the existing structure of the Model and the Data Source Query Definition.
This technique will help when decommissioning IQD Data Sources smoothly and can leverage the new and better features available with IBM Cognos Package Data Sources like Security, Prompts, Governors etc.,
The scope of this technique is... [Continue Reading]

Business Analytics Education has released an updated version of the IBM Cognos WBT Customization Toolkit . This multimedia-based reference to customizing our current web-based training (WBTs), allows clients to take on customization tasks themselves.
The IBM Cognos WBT Customization Toolkit is applicable only to Enterprise WBT sales. They can be positioned for new WBT sales, or if you have clients that already purchased titles and are looking to partner on customization, the Toolkit may be an... [Continue Reading]

IBM Cognos TM1 is an enterprise planning software platform that can transform your entire planning cycle, from target setting and budgeting to reporting, scorecarding, analysis and forecasting.
The following example is an adapted exercise from the IBM Cognos TM1: Administer the Technical Environment (V10.2) two-day instructor led training course. It combines lecture material and interactive practice in installing and administering the Cognos TM1 environment. In addition, the course outlines how the architecture can be customized to fit... [Continue Reading]

Submitted by Mitesh Joshi, TaTa Consultancy Services
There are various options to pass the parameter from a front-end interface to the executing query. Prompt pages or user login pages are basic modes examples where a user can achieve this. Various prompts available in Cognos for this are: Text box prompts, Value prompts, Select & search prompts.
A checkbox selection with the prompt input option is a frequent requirement. Ffor example, a user may want a checkbox option for selection of all and a text box for... [Continue Reading]

Submitted by Vishal Jain, Neha Sambare and Archana Mestry of TaTa Consultancy Services
This document describes the various Javascripts which can be used to modify the various prompt controls in Cognos 10. The examples in this document were tested against IBM Cognos BI 10.1 using Report Studio. The code may need some modifications in the functions used, as per the Cognos version being used.
The document covers the following prompt controls which can be modified using Javascripts:
Changing default options for Search... [Continue Reading]

Submitted by Patrick O'Connor, Communications Strategist for the IBM Electronic Support Adoption Team.
Site Technical Contact 101
"Site Technical Contact 101"
This 4 minute video explains the roles and responsibilities of the IBM Site Technical Contact, or STC. Each organization selects an STC when it purchases software from IBM.
Your Site Technical Contacts play an important role to ensure your organization can easily access IBM Support.
Common STC... [Continue Reading]

Tags

A tag is a keyword you assign to make a blog or blog content easier to find. Click a tag to find content that has been assigned that keyword. Click another tag to refine the search further. Click Find a tag to search for a tag that is not displayed in the collection.