 |
|
|
|
|
|
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 |
|
| |
Data Importing using IIF function for IBM Cognos Controller
This document will explain how to use IIF functions with importing data into IBM Cognos Controller.
|
|
Articles |
|
23 Nov 2009 |
|
| |
Guidelines to building Cash Flow in IBM Cognos Controller
This document will describe the process to create cash flow in IBM Cognos Controller.
|
|
Articles |
|
19 Nov 2009 |
|
| |
Guidelines in including subgroup companies in datamart
Document will provide guidelines on how to include subgroups in datamart template.
|
|
Articles |
|
19 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 |
|
| |
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 |
|
| |
Guidelines to IBM Cognos Controller Functions
This document will provide information on the IBM Cognos Controller Excel Functions.
|
|
Articles |
|
17 Nov 2009 |
|
| |
Building Period Close Schedules in IBM Cognos Controller
This document will provide guidelines to building period ending closing schedules for IBM Cognos Controller.
|
|
Articles |
|
17 Nov 2009 |
|
| |
Integrating IBM Cognos 8 with Perforce
This article shows you how to integrate the widely used Configuration Management System, Perforce, with IBM Cognos.
|
|
Articles |
|
13 Nov 2009 |
|
| |
Integrating IBM Cognos 8 with CA Siteminder
This document describes how to integrate IBM Cognos 8 with the CA Siteminder for authentication. It will describe how to leverage CA Siteminder with IBM Cognos BI in particular but mention general concepts and things to know about when integrating with other IBM Cognos products as well.
|
|
Articles |
|
13 Nov 2009 |
|
| |
Guidelines to Yearend Procedures for IBM Cognos Controller
This document will provide guidelines to closing yearend and starting a new yearend in IBM Cognos Controller Application.
|
|
Articles |
|
13 Nov 2009 |
|
| |
Guidelines to logging out users and times out for IBM Cognos Controller
This document will provide guidelines to logging out users from IBM Cognos Controller.
|
|
Articles |
|
12 Nov 2009 |
|
| |
Guidelines to setting up menu items for IBM Cognos Controller
This document will provide information on customizing Menu Items in IBM Cognos Controller.
|
|
Articles |
|
12 Nov 2009 |
|
| |
Guidelines to Consolidation by Steps or Status - IBM Cognos Controller 8X
This document will provide guidelines to running consolidation by status or by steps.
|
|
Articles |
|
12 Nov 2009 |
|
| |
Creating Mailing Lables in IBM Cognos 8 Report Studio
This document will outline how to create mailing labels in IBM Cognos 8 Report Studio.
|
|
Articles |
|
03 Nov 2009 |
|
| |
Enabling Kerberos SSO in IBM Cognos Express
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 6 Web server.
|
|
Articles |
|
28 Oct 2009 |
|
| |
How IBM Cognos Planning Scales
This document will help technical and administrative users of IBM Cognos Planning to understand the nature of some scaling behaviors.
|
|
Articles |
|
27 Oct 2009 |
|
| |
Prompt for Groups of Data with Common Syntax in IBM Cognos 8 Report Studio
In some cases users would like to return groupings of data based on common words found in the data itself. This document illustrates how authors can incorporate data grouping prompts using macros in a report filter.
|
|
Articles |
|
22 Oct 2009 |
|
| |
Tuning Job Servers in Cognos Planning
How to tune job servers in Cognos Planning to allow for maximum hardware usage, and less locking delays.
|
|
Articles |
|
16 Oct 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 |
|
| |
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 |
|
| |
IBM Cognos TM1 Back-up and Recovery Guide
This document provides guidance on implementing a backup and recovery policy for IBM Cognos TM1 data.
|
|
Articles |
|
07 Oct 2009 |
|
| |
Efficient Report Design using Excel addin
This document will provide guidelines to designing reports using the Excel add-in link.
|
|
Articles |
|
06 Oct 2009 |
|
| |
Transfer Data from TM1 to IBM Cognos Controller with a TM1 Process
This document will provide information on using Turbo Integrator with IBM Cognos Controller.
|
|
Articles |
|
05 Oct 2009 |
|
| |
Guidelines to importing data using lookup splits - IBM Cognos Controller
This document will provide information around using lookup splits to break different types of balances and move them from asset to liability account.
|
|
Articles |
|
01 Oct 2009 |
|
| |
Configuring Intercompany Dividend Elimination - IBM Cognos Controller 8x
This document will provide guidelines to configuring the elimination dividends using the intercompany control tables.
|
|
Articles |
|
29 Sep 2009 |
|
| |
Installing and Configuring the JBOSS Application Server for IBM Cognos 8
This document give extra instructions to set up JBoss against IBM Cognos 8.4 environment.
|
|
Articles |
|
29 Sep 2009 |
|
| |
SAP Web Configuration and IBM Cognos 8 Deployment
This document is for those who have limited experience with SAP Web Application Server (SAP WAS) and who wish to set up a SAP WAS environment. The document consists of detailed instructions that explain the steps required. The primary goal is to set up a basic environment for testing purposes and not necessarily a high performance production environment.
|
|
Articles |
|
29 Sep 2009 |
|
| |
Sun Java Systems Application Server (SJSAS) Installation
This document give extra instructions to set up Sun JSAS against IBM Cognos 8.4.
|
|
Articles |
|
29 Sep 2009 |
|
| |
BEA WebLogic Configuration and IBM Cognos Application Deployment
This document give extra instructions to set up BEA Weblogic against IBM Cognos 8.4.
|
|
Articles |
|
29 Sep 2009 |
|
| |
Installing and Configuring the IBM Cognos Application
This document give extra instructions to set up IBM Cognos 8.4.
|
|
Articles |
|
29 Sep 2009 |
|
| |
Installing and Configuring Oracle 10g Application Server for IBM Cognos 8.4
This document give extra instructions to set up Oracle 10g against IBM Cognos 8.4 environment.
|
|
Articles |
|
29 Sep 2009 |
|
| |
BEA WebLogic - Installing the Application Server
This document descibes how to setup and configure BEA Weblogic against IBM Cognos 8.4 BI.
|
|
Articles |
|
29 Sep 2009 |
|
| |
Configure SAP Application Server against IBM Cognos 8.4
This document give extra instructions to set up SAP Application server against IBM Cognos 8.4.
|
|
Articles |
|
29 Sep 2009 |
|
| |
IBM Cognos Special Edition - Installation and Configuration
This document gives extra instruction on the installation and configuration of the IBM Cognos 8.4 Special Edition.
|
|
Articles |
|
29 Sep 2009 |
|
| |
IBM Cognos 8 and WebSphere Clustering
This document describes how to set up IBM Websphere clustering for a IBM Cognos 8.4 Environment.
|
|
Articles |
|
29 Sep 2009 |
|
| |
Eliminating Interco Dividends using Automatic Journals
This document will provide guidelines to using automatic journals to eliminate intercompany dividends.
|
|
Articles |
|
28 Sep 2009 |
|
| |
System Management Methodology
Documentation and resource files for System Management Methodology.
|
|
Articles |
|
24 Sep 2009 |
|
| |
Global Deployment Guide
Locale considerations for a IBM Cognos Series 7 deployment.
|
|
Articles |
|
16 Sep 2009 |
|
| |
Guidelines to Currency Translation in IBM Cognos Controller
Document will provide guidelines to handling investment adjustment when 100 percent ownership exists.
|
|
Articles |
|
02 Sep 2009 |
|
| |
Understanding Unexpected Drill-Through Behavior in IBM Cognos 8
This document is intended as a reference guide for various IBM Cognos 8 BI drill-through scenarios in which the results may be unexpected.
|
|
Articles |
|
02 Sep 2009 |
|
| |
IBM Cognos 8 Go! Dashboard FP1 and FP2 Companion Guide
This document will help assist any installation issues that might occur while installing, configuring and using IBM Cognos 8 Go! Dashboard FP1 or IBM Cognos 8 Go! Dashboard FP2.
|
|
Articles |
|
26 Aug 2009 |
|
| |
Understanding IBM Cognos 8 PowerPlay Performance
This document is intended to provide IBM Cognos Series 7 PowerPlay administrators an overview of the tuning mechanisms in place for IBM Cognos 8 PowerPlay.
|
|
Articles |
|
20 Aug 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 |
|
| |
Setting Up a Microsoft SQL Server JDBC Connection within IBM Cognos Vitrual View Manager
This document outlines the steps required to setup a Microsoft SQL Server Java Database Connectivity (JDBC) connection within IBM Cognos Virtual View Manager.
|
|
Articles |
|
12 Aug 2009 |
|
| |
Using a WSDL Data Source within IBM Cognos Virtual View Manager
The document provides the steps for preparing the WSDL data for consumption via IBM Cognos 8.
|
|
Articles |
|
12 Aug 2009 |
|
| |
Setting up SAP Connectivity within IBM Cognos Virtual View Manager
This document outlines the steps required to connect IBM Cognos Virtual View Manager to a SAP R/3 data source.
|
|
Articles |
|
07 Aug 2009 |
|
| |
Cognos 8.4 FP1 - BI stability package
The Stability Package describes how to use Apache JMeter to test stability of an IBM Cognos 8 install. It contains a ready to use JMeter plan and a doument describing setup and usage. This version is for IBM Cognos 8.4 FP1.
|
|
Articles |
|
04 Aug 2009 |
|
| |
Integrating IBM Cognos Planning into a SSL enabled Dispatcher
How to enable IBM Cognos Planning to communicate with a SSL-enabled Dispatcher.
|
|
Articles |
|
30 Jul 2009 |
|
| |
Integrating TM1 9.4 and IBM Cognos 8.4
This document describes configuring integration points between TM1 and IBM Cognos 8.
|
|
Articles |
|
27 Jul 2009 |
|
| |
Investment Adjustment when 100 Percent ownership exists for IBM Cognos 8 Controller
Document will provide guidelines to handling investment adjustment when 100 percent ownership exists.
|
|
Articles |
|
23 Jul 2009 |
|
| |
Building Notes to Financial Statements in IBM Cognos Controller
The document provides guidelines to building notes/commentary in IBM Cognos Controller.
|
|
Articles |
|
23 Jul 2009 |
|
| |
Consolidation Process using Batch Servers in IBM Cognos Controller
Document will provide guidelines using Batch Servers with the Consolidation Process.
|
|
Articles |
|
23 Jul 2009 |
|
| |
Using URLs to call IBM Cognos PowerPlay 8 Content
This document provides step by step instructions for creating a Uniform Resource Locator (URL) to evoke IBM Cognos Powerplay 8 package or report content. These URLs can be used directly in the address box of the web browser or called from another webpage.
|
|
Articles |
|
22 Jul 2009 |
|
| |
Output Format Differences Overview
This document discusses the differences between various report output types from reports rendered within the IBM Cognos 8 environment.
|
|
Articles |
|
21 Jul 2009 |
|
| |
Dynamically Hiding an Item with Flair
This technique dynamically hides and displays report items with some visual flair using transition filters.
|
|
Articles |
|
21 Jul 2009 |
|
| |
IBM Cognos 8 BI Dimensional Functions
A list of the available dimensional functions in Cognos 8 with supporting example usage and output.
|
|
Articles |
|
21 Jul 2009 |
|
| |
Designing a Successful Performance and Scalability Test
The purpose of this document is to help guide people with designing a successful Performance and Scalability test with Cognos 8. It is a very high level approach outlining some key principles of Performance and Scalability.
|
|
Articles |
|
20 Jul 2009 |
|
| |
Scripting Basic Report Execution using LoadRunner
This document is intended for individuals using LoadRunner to drive Performance, Scalability, and Stability tests for Cognos 8. The topic covered will be the action of executing simple reports in Cognos Viewer. For the scope of this document only HTML output will be discussed.
|
|
Articles |
|
20 Jul 2009 |
|
| |
Handling Security Changes
This document provides best practices around handling security changes, both reactive and proactive. Things like changing namespaces, moving external users, CAMID details are covered.
|
|
Articles |
|
15 Jul 2009 |
|
| |
Cognos 8.4 RTM - BI stability package
The Stability Package describes how to use Apache JMeter to test stability of an IBM Cognos 8 install. It contains a ready to use JMeter plan and a document describing setup and usage. This version is for IBM Cognos 8.4 RTM only.
|
|
Articles |
|
15 Jul 2009 |
|
| |
Emulating SAP Hierarchy Prompt Variables within IBM Cognos 8
This document will describe a technique which will allow a Report Designer to emulate the behaviour of SAP BW hierarchy variables with the assistance of a user defined prompt in Report Studio.
|
|
Articles |
|
05 Jun 2009 |
|
| |
Custom Chart Palettes For Report Studio
This article describes the process by which you can add new chart palettes or customize existing chart palettes for use in IBM Cognos 8 Report Studio.
|
|
Articles |
|
14 May 2009 |
|
| |
Best Practices to using Dimension in IBM Cognos Controller
This document will provide guidelines to using dimensionality in IBM Cognos Controller.
|
|
Articles |
|
12 May 2009 |
|
| |
Best Practices to using Company and Group Journals - IBM Cognos Controller 8X
This document will provide guidelines around using company and group journals.
|
|
Articles |
|
12 May 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 |
|
| |
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 |
|
| |
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 |
|
| |
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 |
|
| |
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 |
|
| |
