Solved

Cognos Report Case Sensitivity Issue.

Posted on 2011-09-14
2
1,056 Views
Last Modified: 2012-05-12
I am developing a Cognos report which is reporting a list of codes, unfortunately the underlying data is not all in the same case, so codes exist such as 'ABC12345' and 'abc12345' (the only difference being the case). These codes are actually the same, but Cognos treats them as different - for example when I summarise the data the total is 2 rather than 1. e.g.

ABC12345
abc12345
--------------
2

When in reality this should only be 1, as the data is the same. How can I make Cognos treat the data without case sensitivity. I do not want to play around with database collation, as the problem only exists with this specific case. A fix for the specific report would be good.
0
Comment
Question by:Blowfelt82
2 Comments
 
LVL 28

Accepted Solution

by:
burrcm earned 500 total points
ID: 36535342
Set the data field to function "upper". eg upper(fieldname), then they should all look/act the same.

Chris B
0
 
LVL 8

Expert Comment

by:SNeupane
ID: 36536875
If you are using a count, change that to count distinct but the upper() method suggested above or lower() should convert the text to same case.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to learn business intelligence strategy 12 102
SQL Query with GROUP BY 12 99
SSRS Grouping Detail rows 2 68
Tools to Output documents from DB based on selections 8 124
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question