COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: kado on 14 Sep 2010 12:53:40 PM

Title: By default Case Sensitive
Post by: kado on 14 Sep 2010 12:53:40 PM
Hello All,

By default Framework Manager is case sensitive in that ... if I have 1 source with ALL CAPS and then I switch to another source (same table and field names) that has the column names all lower case:

1) the physical layer goes to validate this and then changes everthing
2) My 2nd semantic layer is now invalid and the only way I can get back in action is to go into every single field an re-point them to the new lower case fields (painful)

Is there any option or setting I could change to make Framework Manager case in-sensitive?

thanks,
kado
Title: Re: By default Case Sensitive
Post by: Alp on 29 Sep 2010 05:12:42 PM
Not that I have an answer for you, but to my best recollection you may have SQL Server database that may be created as case sensitive and that involves not only the content of the tables but also tables and property names. So for example <Select A from T> will return object not found if you create table in the database as t.a.


I think this might be a reason why FM plays safe ...

- Alp