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

 

Editing query subjects to include special characters in query items

Started by Jaspire, 11 May 2008 01:21:18 PM

Previous topic - Next topic

Jaspire

Hi,
I am editing Query subject to include , and other characters like ' in the names of the fields pulled through the SQL. But the SQL is not validated. I enclosed the name in "". But still I am getting error. Can you please advice me on how I can give names to the queryitems which include special characters?
Thanks,
Jaspire

almeids

Given that Cognos' apps are notoriously fussy about special characters, and given that even if you can make it work now it is likely to blow up in your face at some point (like during/after an upgrade), why would you want to do that?
Don't risk it (this is a dozen years of Cognos and untold hours of troubleshooting special-character-related problems experience speaking).  If it's to make it easier for unsophisticated users to drag and drop, just show them how to edit their column titles, that doesn't take much sophistication.

Jaspire


Thanks Almeids. It seems you had hard time with these special characters. Actually I need to develop a cube which is similar to other exisitng one which was done using Impromptu. So I was looking for a way to get the same type of fileds. But it seems its better if I leave worrying about this.
Thanks again,
Jaspire

almeids

I guess I don't understand what your goal is.  You can rename query columns in your Transformer model, but (other than default Measure names when you first drag them in) those aren't visible to users in the cube anyway.