Print Page - Need cognos 7 parallel function in cognos 8

Title: Need cognos 7 parallel function in cognos 8
Post by: madhancog on 13 May 2010 11:29:42 PM

Hi Gurus,
I am converting IQD files created in cognos7 to cognos 8 Query subject.
i am having Replace function in IQD how can i replace the same with cognos8 function.
ex.
REPLACE(REPLACE("DIM_Phone"."Phone_Industry_name", ',' , ''), '/', '') "Phone_File_Name",

Thanks in advance,
K.M

Title: Re: Need cognos 7 parallel function in cognos 8
Post by: tupac_rd on 14 May 2010 11:06:29 AM

would decode function work

Title: Re: Need cognos 7 parallel function in cognos 8
Post by: rockytopmark on 17 May 2010 11:07:37 AM

Unfortunately, Cognos doesn't have a find/replace function like this, so you would have to leverage one from your Database's list of functions, or concoct one on your own using the substring() and position() functions.

replace() is actually a function in Oracle, so if your RDBMS is Oracle, you should be able to use it directly in your model.

Title: Re: Need cognos 7 parallel function in cognos 8
Post by: tupac_rd on 19 May 2010 12:31:01 PM

or try to upgrade the report/catalog from 7.4 to 8.x, and see what function Cognos would use....

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: madhancog on 13 May 2010 11:29:42 PM