If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

By default Case Sensitive

Started by kado, 14 Sep 2010 12:53:40 PM

Previous topic - Next topic

kado

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

Alp

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