IBM developerWorks : Technical library
The latest content from IBM developerWorks
-
IBM Cognos Diagnostics: IBM Business Analytics Diagnostics: Use Case: Viewing All Users and Capabilities in IBM Cognos BI
Gathering capabilities and group/role information associated with users for each namespace.
-
IBM Cognos Proven Practices: The IBM Cognos 10 Dynamic Query Cookbook
This document is intended to provide a single point of reference for techniques and product behaviours when dealing with the Dynamic Query Mode delivered with IBM Cognos 10.
-
IBM Cognos Proven Practices: Performance Tips when using Cross JoinQueries against a TM1 Datasource
The purpose of this document is to provide performance guidance when querying large datasets from a TM1 Datasource.
-
IBM Cognos Proven Practices: IBM Cognos BI - Unexpected Results When Performing Multi-Fact Queries (Stitch Queries)
This document discusses a number of issues that advanced report authors may encounter when they create reports that generate a stitch query (queries that include facts from multiple fact tables).
-
IBM Cognos Proven Practices: Dynamic Sorting of a List within IBM Cognos Report Studio
A technique which applies dynamic column sorting on a list using custom IBM Cognos Report Studio toolbox items.
-
IBM Cognos Proven Practices: Enabling Browsing for Images in IBM Cognos Express Report Studio
The goal of this document is to outline the different ways in which the WebDAV HTTP extension can be enabled for use with the “Browsing for Images” feature in IBM Cognos Express Report Studio.
-
IBM Cognos Proven Practices: Fit PDF Report Output to Page in IBM Cognos BI Report Studio
This short guide demonstrates an easy method of making a report PDF output fit to page, both vertically and horizontally, without impacting the HTML view.
-
IBM Cognos Proven Practices: IBM Cognos BI – Deploy Content Between Environments
This document is intended to provide guidelines around developing business intelligence content and deploying it from one environment to another. For example, deploy content from a Development environment to a Quality Assurance (QA) environment, and then to a Production environment.
-
IBM Cognos Proven Practices: Installing and Configuring IBM Cognos Lifecycle Manager for Optimum Results
This document describes how to register Lifecycle Manager as a Windows service.
-
IBM Cognos Proven Practices: Using IBM Cognos 10 Virtual View Manager for Federated Queries
An overview of the IBM Cognos Virtual View Manager semijoin functionality and how it affects the federated queries.
-
IBM Cognos Proven Practices: Mimicking IBM Cognos Series 7 Drill-Through in IBM Cognos BI
This document is to assist customers to migrate IBM Cognos PowerPlay Cube to relational drill through reports from IBM Cognos 7.4 to IBM Cognos BI.
-
IBM Cognos Proven Practices: IBM Cognos Enhanced Search Proven Practice
A best practice for configuring Enhanced Search services, as well as creating and maintaining your search index.
-
IBM Cognos Proven Practices: Scheduling a Metadata Backup in IBM Cognos Real-time Monitoring
This article provides information on different ways to automatically backup/export metadata from an IBM Cognos Real-time Monitoring (or IBM Cognos Now!) server and how to schedule these backups.
-
IBM Cognos Proven Practices: Enabling Kerberos SSO in IBM Cognos Express on Windows Server 2008
This document describes and demonstrates the basic steps that are required in order to enable Integrated Sign On (or Single Sign On) with Active Directory in IBM Cognos Express using the Microsoft IIS 7 Web server on Windows Server 2008.
-
IBM Cognos Proven Practices: Conditional Business Reporting Based on Relative and Absolute Dates within IBM Cognos Report Studio
An approach to presenting a ‘relative date’ to a report consumer within a prompt or set of prompts. Many organizations might need relative date activity such as the activity in the last 7 days, Month to date, Year to Date.
-
IBM Cognos Adaptive Application Framework V8.4, Part 2: Create a new dimension from a non-ERP data source
Watch this demo to learn how to create a new Warehouse Dimension that is sourced from a non-ERP or custom data source.
-
IBM Cognos Proven Practices: Using Active Report Variables in Cognos 10
A demonstration of enabling the ability to view variables for Active Reports and monitor their behavior in a working report.
-
IBM Cognos Proven Practices: Configure IBM Cognos BI to Authenticate with Novell eDirectory8 via LDAPS
How to configure an IBM Cognos BI LDAP authentication provider to attach to Novell eDirectory 8 by LDAPS.
-
IBM Cognos Proven Practices: IBM Cookbook for IBM Cognos 10 for use with SAP NetWeaver Business Warehouse™
This document is intended to provide a single point of reference for techniques and product behaviours when dealing with SAP® NetWeaver® Business Warehouse® (SAP BW) as a data source in IBM Cognos 10.
-
IBM Cognos Proven Practices: Customizing IBM Cognos 10 Login
This document is meant to supplement the Security and Administration Guide of IBM Cognos 10 by providing sophisticated examples for customizing the login page.
-
IBM Cognos Proven Practices: Block Publishing Packages to an IBM Cognos 8 Environment
This technique prevents Framework Manager from publishing packages to a given IBM Cognos 8 environment by leveraging a Servlet Filter. This file contains a document next to binaries implementing the technique.
-
IBM Cognos Proven Practices: Transform IBM Lotus Quickr Document Metadata For IBM Cognos BI
A Java utility to extract metadata on Lotus Quickr Document objects and transform that metadata into an IBM Cognos BI XML data source using an XSLT stylesheet.
-
IBM Cognos Proven Practices: IBM Cognos BI - Restrict Tree Prompt Selection with JavaScript
A technique for report developers that wish to utilize a Tree Prompt but require that the value submitted be restricted to a designated level within a hierarchy.
-
IBM Cognos Proven Practices: Using DB2 Row Compression in Adaptive Warehouse Projects
This document describes implementation of DB2 row compression in an Adaptive Warehouse generated data warehouse.
-
IBM Cognos Proven Practices: Deploying Content from the Adaptive Application Framework 8.4 to Cognos Business Intelligence 10.1
A description of how users of IBM Cognos Analytic Applications can benefit from the new capabilities in their IBM Cognos 10.1 BI production environment while continuing to take full advantage of their existing Analytic Applications.
-
IBM Cognos Proven Practices: Working with Prompt Parameters in the Adaptive Application Framework
Recommendations and tips on using prompt parameters in the IBM Cognos Analytic Applications. Filter structures in the warehouse model, their use by Adaptive Analytics, and report manager controls are discussed.
-
IBM Cognos Proven Practices: Working with Large Metadata Models in Adaptive Warehouse
Techniques for managing how much memory is used and how to extend the available memory on Windows-based operating systems when there is a requirement to assemble many subject areas together into an Adaptive Warehouse project.
-
IBM Cognos Proven Practices: Sample of Report Building using the Excel Add-in Link for IBM Cognos Controller
This document will provide samples of reports that can be built using the excel addin link.
-
IBM Cognos Proven Practices: Multi e.List item simulation
This document describes how to open many leaf elements at the same time while applying the IBM TM1 Contributor security to them.
-
IBM Cognos Proven Practices: Trouble Shooting General Configuration and Automatic Journals for IBM Cognos Controller
This document will provide trouble shooting techniques for automatic journals and general configuration.
-
IBM Cognos Proven Practices: IBM Cognos BI - Global Filters for a Multi-Page Dashboard
This document will illustrate how to implement global filters that filter reports in a Multi-page portlet in an IBM Cognos portal page.
-
IBM Cognos Proven Practices: Guidelines to Using Integrated Accounts with General Configuration in IBM Cognos Controller
Guidelines to setting up and using historical rates in IBM Cognos Controller.
-
IBM Cognos Proven Practices: IBM Cognos Planning – Data Validation Example
A supplement to the IBM Cognos Planning product documentation in the area of Data Validations. This document will provide an example of creating a Data Validation for IBM Cognos Planning.
-
IBM Cognos Proven Practices: Guidelines to Using Historical Rates in IBM Cognos Controller
Guidelines to setting up and using historical rates in IBM Cognos Controller.
-
IBM Cognos Proven Practices: Installing FAP for IBM Cognos Controller 8.5
Guidelines for installing and configuring Financial Analytics Publisher.
-
IBM Cognos Proven Practices: Troubleshooting the IBM Cognos Planning Contributor Rich Client
This document provides techniques to troubleshoot the installation of the Planning Rich Client.
-
IBM Cognos Proven Practices: Guidelines to General Configuration and Automatic Journals for IBM Cognos Controller
How to set up both general configuration and automatic journals.
-
IBM Cognos Proven Practices: Automating Deployment of IBM Cognos 8 BI
A deployment methodology for a development and production environment.
-
Cognos cloud best practices: Choosing the settings to enable high availability
The goal of high availability is to provide a backup mechanism to transfer requests and data processing to a standby system in the event of primary system failure, but user and system requirements vary, meaning there is no one ideal configuration. This article provides a number of recommendations for setting up and maintaining the Cognos solution for high availability and for disaster recovery.
-
IBM Cognos Proven Practices: PowerPlay Transformer Model Check List
Guidelines on what to check when preparing and reviewing a Transformer model pre-production.
-
IBM Cognos Proven Practices: Guidelines to Special Consolidation Structures in IBM Cognos Controller
How to setup and configure Z Consolidation Method.
-
IBM Cognos Proven Practices: Benchmarking your IBM Cognos 8 Environment using IBM Cognos Upgrade Manager
During the lifecycle of your IBM Cognos 8 application you may need to update IBM Cognos 8 with a Service Pack, Fix Pack, hotsite or other IBM Cognos updater. This document can be used to provide a guided approach.
-
Cognos cloud best practices: Sizing the architecture for performance and scalability
Cognos 8 is a sophisticated set of products and capabilities. Sizing the architecture can be a challenging task requiring knowledge of expected system overall workload. As a result, expect some iteration on the architecture to customize it appropriately to your requirements. The authors provide some general guidelines and architecture recommendations to support a large-scale deployment of Cognos 8 onto the IBM Cloud.
-
IBM Cognos Proven Practices: Configuring the IBM Cognos Planning Rich Client to Automatically Install when the Server is Secured using SSL
How to deploy the Cognos 8 Planning 8.4 Rich Client via the web in a SSL secured environment.
-
Cognos cloud best practices: Moving from a single- to a multiple-image topology
Just like in a traditional data center, the deployment of Cognos into the cloud may require multiple machines, so your cloud solution may require multiple images. Criteria such as performance, scalability and high availability typically lead to a multi-image topology. The authors demonstrate the best practices for managing this type of multi-image topology.
-
IBM Cognos Proven Practices: Customising the IBM Cognos 8.4.x UI
This document provides some tips and techniques when creating a custom style (or "skin") in IBM Cognos 8.4.x.
-
IBM Cognos Proven Practices: Adding Single Sign-On to your IBM Cognos 8 Custom Java Authentication Provider
This document describes how one can implement SSO to his Custom Java Authentication Provider by explaining the required concepts. This documents supplements SDK documentation.
-
IBM Cognos Proven Practices: IBM Cognos TM1 9.5 Quick Install and Upgrade Guide
This document provides an example of installing and upgrading TM1 9.5 including TM1 9.5 Server, TM1 9.5 Web, and TM1 9.5 Contributor. This example is performed on a Single Server running MS Windows XP 32-bit and using IIS and Apache Tomcat.
-
IBM Cognos Proven Practices: Guidelines to Monitoring Company and Group Status by Form for IBM Cognos Controller
A guideline to creating a report that will help you review status of Company or Group by Form
-
IBM Cognos 8 BI tips and techniques: Change the name of a PowerPlay report in Cognos Connection as it appears in Upfront
Download a Java sample that gives you a way to rename Cognos PowerPlay Enterprise Server views and reports so that they are the same as they appear in Cognos Upfront. Get step-by-step instructions for implementing this code sample.

