Solved

Cognos Report Case Sensitivity Issue.

Posted on 2011-09-14
2
1,025 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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…
How to increase the row limit in Jasper Server.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now