IBM Business Analytics Diagnostics: Use Case: Tracking Down a CSV Export Delimiter Difference Between a Development and Production System

Product(s): IBM Cognos BI; Area of Interest: Infrastructure

In this scenario, a support analyst is presented with a situation where the delimiter of a Comma Separated Value (CSV) report output format is different between an IBM Cognos production and development system.

Business Analytics Proven Practices Team, Business Analytics Proven Practices Team, IBM

Business Analytics Proven Practices Team



20 March 2012

Also available in Russian

Introduction

Purpose

This document is intended to provide a troubleshooting methodology which incorporates publically available utilities (http://www.ibm.com/software/data/support/cognos_sdk.html) to diagnose and resolve an issue identified within a specific use case.

Applicability

Although the troubleshooting approach outlined is not IBM Cognos version specific, some of the diagnostic utilities used are. The version of the utility to be downloaded will be specific to the IBM Cognos version that is experiencing the issue.


Use Case Description

In this scenario, a support analyst is presented with a situation where the delimiter of a Comma Separated Value (CSV) report output format is different between an IBM Cognos production and development system.


Troubleshooting the Use Case

As with troubleshooting any use case, a set of basic information needs to be collected in order to further clarify the environment and the issue at hand. In this particular use case, the following information was provided by the client when logging the initial PMR with support.

  • IBM Cognos version: 8.4.1
  • Operating System: Windows
  • Query Database: IBM DB2
  • Content Store Database: IBM DB2

Also as part of the initial conversation, the support analyst ascertains that both the IBM Cognos production and development systems are identical in architecture, build and business content. Naturally the production report data is provided by a production IBM DB2 database while the development reports use an IBM DB2 development system where the data volume has been pared down.

Further Clarifying the Issue at Hand

The analyst has the client step through the issue through a remote session. In that session the issue is further clarified as the CSV report export from the IBM Cognos production system is not actually comma separated. This causes an issue with the client as the file is not readable as a data source by IBM Cognos PowerPlay Transformer.

Comparing the Differences Between the IBM Cognos Production and Development System

The support analyst decides to start at comparing the differences between the two actual systems the IBM Cognos environments are installed on. In order to do this, the support analyst uses the System Overview Diagnostic located at: http://www.ibm.com/support/docview.wss?uid=swg24020682

This utility obtains such system information as Computer Name, Operating System version and environment variables. After stepping the client through running this utility on the two systems, the client sends in the resultant logs to the support analyst.

Upon receiving the files, the support analyst uses a third party compare utility, such as Beyond Compare, to identify environmental differences between the two systems. Although there are a few expected differences, the support analyst does not find anything that is pertinent to the issue at hand. Due to this, the support analyst deduces that the issue maybe caused by a difference in the IBM Cognos system configuration.

The support analyst uses the IBM Cognos BI Dispatcher Diagnostic located at: http://www.ibm.com/support/docview.wss?uid=swg24021220

This utility not only gathers the configuration settings associated with an IBM Cognos dispatcher, but also identifies any changes made to default configurations.

The client runs this utility on the problem IBM Cognos production system first and notices that none of the configurations have changed from the defaults applied during the install of the product.

The client then runs the same utility on the IBM Cognos development system. This time the utility highlights a change in the IBM Cognos dispatcher advanced settings. The IBM Cognos development system has a setting of: RSVP.CSV.DELIMITER set to ,.

Delivering the Findings

The client calls the support analyst to discuss these findings. After listening diligently, the support analyst quickly locates the technote located at: http://www.ibm.com/support/docview.wss?uid=swg21439447 which provides the steps on setting this advanced configuration setting. The support analyst and the client end their conversation and after a day the support analyst received a request to close the call.

Comments

developerWorks: Sign in

Required fields are indicated with an asterisk (*).


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Information in your profile (your name, country/region, and company name) is displayed to the public and will accompany any content you post, unless you opt to hide your company name. You may update your IBM account at any time.

All information submitted is secure.

Choose your display name



The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

Required fields are indicated with an asterisk (*).

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 


All information submitted is secure.

Dig deeper into Big data and analytics on developerWorks


static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Business analytics, Information Management
ArticleID=804221
ArticleTitle=IBM Business Analytics Diagnostics: Use Case: Tracking Down a CSV Export Delimiter Difference Between a Development and Production System
publish-date=03202012