 |
|
|
|
|
|
Cognos Proven Practices documentation
This landing page contains links to all the Cognos Proven Practices documentation.
|
|
|
|
27 Jul 2009 |
|
| |
Cognos Metrics Designer and PowerCubes Proven Practices
The purpose of this document is to provide Cognos Metric Designer (CMD) users guidance on defining time mappings for Powercube Import Sources.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Proven Practices for Application or Manually Created FM Model XML Documents
Describes the proven practices for using models created either manually or through another application.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Installing and Configuring Controller 8.3 Server - Proven Practice
This document is intended to demonstrate how best to install the IBM Cognos Controller 8.3 server on a single application server.
This document shall intentionally cover a basic standard installation, using one application server and Microsoft SQL.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Top 10 Cognos Financial Performance Management Proven Practices
This landing page contains links to last month's 10 most popular Cognos FPM Proven Practices, based on web hits.
|
|
|
|
12 Nov 2009 |
|
| |
Top 10 Cognos Business Intelligence Proven Practices
This landing page contains links to last month's 10 most popular Cognos IB Proven Practices, based on web hits.
|
|
|
|
12 Nov 2009 |
|
| |
Proven Practice - Step by Step guide to installing Oracle 10G Client on a Controller 8.3 Application Server
This document will show how to install/configure the Oracle 10G release 2 client on a Controller 8.3 Application server, and then configure Controller 8.3 to point to the appropriate Oracle 10G (release 2) database/server.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Securing the IBM Cognos 8 BI Environment
This document provides a set of proven practices, to be taken into consideration when securing the Cognos 8 reporting environment.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Sharing a Secured IBM Cognos 8 BI Environment
A set of proven practices to be used when securing the Cognos 8 reporting environment. The recommendations are designed to be used in an environment that requires more than one security source, but where the security sources are mutually exclusive.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Saving Report Output to the Server File System
This document was created to provide a single point of instructions to successfully enable the “saving report output to the file system” feature in IBM Cognos 8.
|
|
Articles |
|
27 Nov 2009 |
|
| |
Installing and Configuring the Symbian Simulator for IBM Cognos Go! Mobile
This document provides step by step instructions on how to install and configure the Symbian Simulator for use with IBM Cognos Go! Mobile.
|
|
Articles |
|
01 Jan 2009 |
|
| |
IBM Cognos TM1 Web Tips and Techniques
This document describes various tips and techniques that will improve functionality, ease administration, and improve performance of IBM Cognos TM1 Web applications.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Intercompany Elimination Process when Counter Company is Unknown - IBM Cognos 8 Controller
The intercompany elimination requires that the counter party to be identified. However, there are circumstances that exist when the counter party is not known and the intercompany transactions are required to be eliminated. This document will show you an alternative to loading intercompany balances when the counter party is not known.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Passing Use and Display Values on a URL
This document focuses on passing 'Display values' as the primary value, and also includes details on how to pass complex parameters such as ranges.
|
|
Articles |
|
18 Aug 2009 |
|
| |
Durable Models
This document discusses some of the concepts behind designing a durable model to help with the lifecycle of a model in an organization.
|
|
Articles |
|
15 Oct 2009 |
|
| |
Bridge Tables and IBM Cognos 8
A technique for modeling bridge tables. Bridge tables serve to provide many to many linking relationships between stand-alone star schemas. The zip file contains the document, sample data, and Framework Manager model.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Dimensional Modeling for Time Period Analysis
A technique for Dimensionally Modelled Relational datasources that will allow for relative time period analysis within crosstabs. This technique focuses on developing period-to-date aggregates.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Using the script option to rename PDF files to the Burst Key value
Burst output can be directed to a file system rather than being stored within the Content Store. This process produces uniquely named output files created with a generated key. A script can be used to rename these files according to the burst key value.
|
|
Articles |
|
15 Oct 2009 |
|
| |
Guide to installing Oracle 9i with Controller
This document will default settings for installing Oracle 9i (release 2) - also known as "Oracle 9.2.0.1" - on Windows 2003. We should also patch it to Cognos "recommended level (9.2.0.73) and create some databases for the Controller System
|
|
Articles |
|
01 Jan 2009 |
|
| |
Handling Report Output Using The SDK
How to use the SDK to handle report outputs formats. Topics include handling the various output formats and how report outputs are stored in the Content Store. This document was the basis for the article in SupportLink Volume 16 No 3 July-August 2006.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Guidelines to configuring Intercompany Profit - IBM Cognos 8 Controller 8.x
This document provides guidelines to configuring intercompany profit.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Repeat Crosstab Labels in CSV
Details on how to modify the Report Service and Batch Report Service to change the generation of CSV output files to include an instance of the row or column labels for each column rather than one label per set of child rows or child columns.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Guidelines to Different Consolidation Methods in IBM Cognos Controller 8
This document will provide a review of the various consolidation processes.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Scripting FM Metadata Updates
This document demonstrates a simple script that can be used to update a Framework Manager model with information that can be obtained from a metadata repository.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Installing Business Viewpoint with SQL Server
This document provides a guideline for installing and configuring IBM Cognos 8 Business Viewpoint into a SQL Server 2005 environment.
|
|
Articles |
|
18 Nov 2009 |
|
| |
Configuring SSL for Business Viewpoint
This document walks through generating the SSL certificate, and making the necessary configuration changes in Business Viewpoint to allow the use of SSL.
|
|
Articles |
|
18 Nov 2009 |
|
| |
Understanding the New Contributor Web Grid
This document will discuss the technology used in the new Contributor Eclipse based grid, as well as install routines, and setting modifications. It will also cover logging.
|
|
Articles |
|
18 Nov 2009 |
|
| |
IBM Cognos 8 Audit Extension
An IBM Cognos 8 SDK application that provides enhanced auditing for IBM Cognos 8 BI. The version of the application is 1.5.04 and it will work with IBM Cognos 8 BI versions 8.3 and 8.4.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Creating IBM Cognos Controller Databases using Microsoft SQL Server
This document will provide information on setting up a Microsoft SQL Server Database to work IBM Cognos Controller.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Intercompany eliminations with details in a separate data load - Controller
This document will provide you with some guidelines to eliminate intercompany when the details are loaded separately into Controller, i.e. sub ledger or sub-system.
|
|
Articles |
|
01 Jan 2009 |
|
| |
How to install the IBM Cognos Controller 8.4 Client on a users PC
This document is intended to demonstrate how best to install the IBM Cognos Controller 8.4 client on an end-user's PC.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Controller 8.3 - New Features
This document includes information on the new features or the enhancements in Cognos Controller 8.3
|
|
Articles |
|
01 Jan 2009 |
|
| |
Notes on Report Bursting in Cognos 8.3
Details on using one or more queries to burst list and crosstab reports. The additional queries can be used to separate the data for the burst groups, recipients, and report data. A new feature to IBM Cognos 8.3 for multiple recipients is also described.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Report Studio - Extended Data Items
Details on the new Extended Data Items available in IBM Cognos 8.3. The additional features that these new items enable in Report Studio are listed and explained along with recommendations for authoring reports for Express Mode users.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Monitoring the Audit Database using Event Studio
The purpose of this document is to get familiar a technique which can be used to extract information from the audit logs and integrate the information with warning emails generated from Event Studio.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Guideline to importing data using staging tables - IBM Cognos Controller 8
This document will provide additional information on using the staging tables to import data into IBM Cognos Controller and will include samples of the import specification, data files, etc.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Preparing a WSDL Service within Composite 4.5.0 for Framework Manager
This document provides step by step instructions for importing WSDL as a data source within Composite Studio. The document also provides the steps for preparing the WSDL data for consumption via Cognos 8.3 Framework Manager.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Dynamic Dashboards in IBM Cognos 8.3 with Burst Reports
This document is designed to show the dynamic dashboard capabilities of some of the portlets in IBM Cognos 8.3. The technique will outline the steps needed to create burst reports and portal pages that will ensure inter portlet communication.
|
|
Articles |
|
01 Jan 2009 |
|
| |
WAN Performance of IBM Cognos 8
Architectural Guidance and Discussion regarding WAN deployments of Cognos 8.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Turbo Integrator Data Processing Tips and Techniques
This is a compilation of various tips and techniques on using Turbo Integrator to transform and load data into IBM Cognos TM1.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Guideline to changes in Group Structures for IBM Cognos Controller 8x
This document will provide guidelines to making structural changes in IBM Cognos Controller.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Connecting IBM Cognos TM1 to Various Third-Party Data Sources
This document provides some examples of connecting IBM Cognos TM1 to various 3rd party data sources using ODBO, ODBC, and the TM1 API. Note that most of the 3rd party software is not the current release.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Dynamic Dashboards in IBM Cognos 8.3 with Metric Studio Content
Build dynamic dashboards in IBM Cognos 8.3, incorporating content from Metric Studio.
|
|
Articles |
|
01 Jan 2009 |
|
| |
TM1 Deployment Options and Bandwidth Considerations
The scope of this article is to discuss and compare deployment options for TM1 and to recommend LAN and WAN configurations necessary for achieving minimum acceptable network performance for the user.
|
|
Articles |
|
01 Jan 2009 |
|
| |
TM1 Server Administration
This document is a compilation of recommended practices on the topic of TM1 server planning, sizing, and hardware performance.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Guidelines to Importing Data into Contoller using Data Manager and Staging Tables
This document will provide guidelines to using both data manager and staging tables to import data into Controller.
|
|
Articles |
|
01 Jan 2009 |
|
| |
IBM Cognos Planning as a Data Source for IBM Cognos BI Reports
This document introduces readers to the improvements in reporting from Cognos Planning and Cognos 8 bi, focused on techniques to improve presentation, navigation and enrich content.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Installation Methods for Contributor Web Client
This document discusses the different methods for installing the Contributor Web Client onto a user's workstation.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Calculations that Span Dimensions
Techniques for creating summary functions and calculations that operate across disjoint edges of a query. For example, a total or percent of base calculation that operates across two different dimensions on the rows of a crosstab.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Data Import
The purpose of this document is to layout the different approaches to importing data into Controller.
|
|
Articles |
|
01 Jan 2009 |
|
| |
8.2 Controller_Implementing Security
Cognos Controller allows various methods to secure your applications.
You can create groups of data items - and apply the different items to the different users or user classes in order to tailor their data access rights.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Implementing Security in IBM Cognos 8 Controller
Cognos Controller allows various methods to secure your applications.
You can create groups of data items - and apply the different items to the different users or user classes in order to tailor their data access rights.
|
|
Articles |
|
01 Jan 2009 |
|
| |
IBM Cognos 8 Go! Mobile BlackBerry "Pull" Install
This document contains the steps required for a BlackBerry user to install the Cognos 8 Go! Mobile client on their mobile device.
|
|
Articles |
|
01 Jan 2009 |
|
| |
How to import a WSDL Data Source and Prepare it for Use in Framework Manager
This document provides step by step instructions for importing WSDL as a data source within Composite Studio. The document also provides the steps for preparing the WSDL data for consumption via Framework Manager.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Summary Level-to-Detail Level Planning
This document provides an example of using Cognos Planning to create models that solicit input at a summary level to ease the burden on contributors while still providing the level of detail required for management.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Migrating Analyst Environments
This document provides a step-by-step approach to migrating Cognos Planning - Analyst to new environments.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Improved Performance by Flattening Dimensions
This document provides a technique for combining multiple dimensions into a single dimension to improve performance for large Cognos Planning models. The technique can also be used to reduce data sparsity in Cognos Planning models.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Multi-Server Install for Controller
This document is meant to outline the basic configuration settings to get controller up and working in what we have found to be a "Typical" multi-server install.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Resolving Double Prompting with SAP BW
The purpose of this document is to explain the added functionality that will eliminate the double prompting of a SAP BW mandatory variable when combined with a user defined prompt in Report Studio.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Single Queries from Multiple Lists
Query generation in Cognos 8 is subject to multiple factors that were not present in ReportNet. Tuning these properties will allow single queries to be executed for multiple lists on a report layout.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Advanced Prompting and Prompt Performance Tuning
This document shows report authors how to deal with prompt page performance issues. This material was presented at the 2007 User Forum as presentation 1562.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Leveraging a Protected Project in a Multi-developer Environment
This document discusses the concept of how to leverage existing functionality within Framework Manager and a Repository Control application to protect a project while allowing multiple developers to access the content at the same time.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Blue Stack - Setting up DB2
An outline of DB2 connectivity and how to use DB2 Connect to connect to IBM databases from Windows and Unix. Detailed instructions are provided for creation of UDB databases for use by Cognos 8, and deployment of Sample data for Cognos 8 and Series 7.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Managing Access Tables in IBM Cognos Planning - Analyst
This document describes a method for managing Cognos Planning - Contributor Access Tables in Cognos Planning - Analyst. This technique may be useful for frequently changing or very large access tables.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Year-to-Date in IBM Cognos 8 Metric Studio
How to mimic CMM 2.x Year-to-date rollups in Cognos 8 Metrics Studio.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Caching Views with Composite 4.0.1
The following document provides step by step instruction on how to enable view caching within the Composite Studio.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Migration to Controller 8.1
The purpose of this document is to share some experiences from Consultants in Sweden regarding migration from Consolidator 6.x to Controller 8.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Pushing the IBM Cognos 8 Go! Mobile Rich Client from the BlackBerry Enterprise Server
Pushing the Cognos 8 Go! Mobile Rich Client from the BlackBerry Enterprise Server
|
|
Articles |
|
01 Jan 2009 |
|
| |
Drill Up/Down
How Member Sets and Advanced Drill behaviours can be leveraged within Report Studio. Descriptions and examples of the advanced drill behaviours are provided.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Conditional Statements
This document covers best practices in creating Conditional Statements in Cognos Planning Analyst.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Java Garbage Collection
How to configure Tomcat to capture Java Garbage Collection logs to file, and a suggested tool for monitoring Heap Utilisation.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Image Indicators in a Crosstab
How to unlock the contents of your crosstab fact cells to include an image. The image is conditionally displayed based on the data included in the crosstab and can be used as a metric indicator for the measure values.
|
|
Articles |
|
01 Jan 2009 |
|
| |
What you need to know before an upgrade from IBM Cognos ReportNet 1.1 to IBM Cognos 8 BI
What you need to know before an upgrade from IBM Cognos ReportNet 1.1 to IBM Cognos 8
|
|
Articles |
|
01 Jan 2009 |
|
| |
Triggering an IBM Cognos 8 Event Externally
Triggering an IBM Cognos 8 Event Externally
|
|
Articles |
|
01 Jan 2009 |
|
| |
Managing Apache WebServer
Specific guidance is provided on the operation and configuration of the Apache WebServer v2.0.x for use with Cognos 8 and Series 7. Updated with content for Cognos GO!Mobile (Blackberry integration) and more notes re Kerberos Single Signon.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Creating Dynamic Analysis Studio Type Reports in Report Studio Part-2
This document expands on part-1 and demonstrates some of the techniques used in making the report more dynamic. Member Sets, Advanced Drill Parameters and some expanded calculations are used.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Creating Dynamic Analysis Studio Type Reports in Report Studio Part-1
This is part 1 of a technique that demonstrates how to replicate Analysis Studio report functionality in Report Studio.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Deploy a secured Cognos 8 Servlet Gateway in IBM WebSphere 6
This document outlines the steps necessary to deploy a Servlet Gateway under WebSphere security for SSO purposes.
Backgrounds on WebSphere security, Servlet Gateway, SSO and deploying a pre-created EAR is covered as well.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Managing Fonts
Where to find TrueType fonts on UNIX, how to install additional fonts, and how to expose them to the IBM Cognos products. Also covers the special-case of rendering data as a Barcode.
|
|
Articles |
|
01 Jan 2009 |
|
| |
External Repository Control
How to use an external repository to manage Framework Manager models without using the repository controls within Framework Manager as with the supported source control systems.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Logging Console and Monitoring
This document describes how to use the Cognos Logging Console.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Using a Crosstab to Produce Gantt Charts
This document outlines how to create Gantt charts, useful in displaying project timelines, as formatted crosstabs for IBM Cognos 8 and IBM Cognos ReportNet. Discussion is limited to the IBM Cognos 8 implementation of this technique.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Migrating Cognos Metrics Manager 2.2 to Cognos 8
Guidelines for moving a Cognos Metrics Manager 2.2 application to Cognos Metrics Studio 8.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Setting up a Connection to LDAP via Composite
A step by step guide to introspecting the Cognos Series 7 namespace as a Composite LDAP datasource.
|
|
Articles |
|
01 Jan 2009 |
|
| |
The Active Directory Story
This document details how IBM Cognos ReportNet and IBM Cognos 8 BI fits into a multi domain Active Directory environment.
|
|
Articles |
|
01 Jan 2009 |
|
| |
IBM Cognos ReportNet and Java Heap
A detailed explaination of some fo the tunning settings available for the Java heap.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Performance Tuning Settings for IBM Cognos 8 BI
This document gives a detailed explanation of the configuration settings available for Cognos 8.
|
|
Articles |
|
01 Jan 2009 |
|
| |
IBM Cognos 8 BI Performance Tuning Cheat Sheet
A quick reference guide to some of the IBM Cognos 8 BI configuration settings.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Upgrading SDK Applications to Cognos 8
Upgrading IBM Cognos ReportNet SDK Applications To IBM Cognos 8.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Security in Framework Manager
This document outlines the possibilities for using security within a Framework Manager model
|
|
Articles |
|
01 Jan 2009 |
|
| |
Resolution of images in Cognos 8 and ReportNet
How Cognos 8 and ReportNet resolve images embedded in reports.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Series 7 Authentication Server Setup
This document is a step by step guide to configuring the Authentication Service in a three tier environment.
|
|
Articles |
|
01 Jan 2009 |
|
| |
PowerPlay Cell Notification in Event Studio
This document shows how a user can recreate the PPES cell notification feature from 7.3 of PPES in Event Studio
|
|
Articles |
|
01 Jan 2009 |
|
| |
Introspecting the Composite MYSQL sample database
A step by step guide on how to setup the samples for the earlier versions of Composite Information Service
|
|
Articles |
|
01 Jan 2009 |
|
| |
Setting Up a MSSQL JDBC connection via Composite
A step by step guide on how to setup a MSSQL JDBC connection as a Composite datasource
|
|
Articles |
|
01 Jan 2009 |
|
| |
Setting Up a Custom JDBC connection with Composite Database
This document is a step by step guide on how to setup a custom JDBC datasource within Composite.
|
|
Articles |
|
01 Jan 2009 |
|
| |
How to import a WSDL Data Source and Prepare for Use in Framework Manager
A guided tour on how to setup a WSDL datasource within Composite for use with Framework Manager.
|
|
Articles |
|
01 Jan 2009 |
|
| |
How to import a Stored Procedure and Prepare for use with Framework Manager
A step by step guide on how to prepare a database stored procedure within Composite for Framework Manager digestion.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Flexible Model Solutions
Theory and practice for designing models with flexibility in mind. Techniques are discussed for planning model scope to make maintenance and reporting easier for both model and report developers.
|
|
Articles |
|
01 Jan 2009 |
|
| |
IBM Cognos ReportNet to IBM Cognos 8 BI
Guidelines for upgrading from IBM Cognos ReportNet to IBM Cognos 8 BI.
|
|
Articles |
|
01 Jan 2009 |
|
| |
