Solved

Cognos Report Case Sensitivity Issue.

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
How to increase the row limit in Jasper Server.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

932 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

20 Experts available now in Live!

Get 1:1 Help Now