Print Page - how to concatenate % or $ with Procedure column

Title: how to concatenate % or $ with Procedure column
Post by: aamuktha on 12 Jan 2006 01:25:24 AM

hi

here is the issue....

i need to concat % to a procedure column..

i have used concat function on table column it is working fine.But the same function is not working with Procedure column.

is it bug in cognos??

for example

EMP is a table

CONCAT(EMP.SAL,%) IT IS WORKING FINE.

PKG_EMP IS A PROCEDURE

CONCAT(PKG_EMP.SAL,%) IS N0T VALIDATING . IT IS GIVING ERROR.

PLEASE SUGGEST ME .

THANKS
aamuktha

Title: Re: how to concatenate % or $ with Procedure column
Post by: JoeBass on 12 Jan 2006 08:38:55 AM

I tried this (with SQL Server) and also got a strange problem. The calculation validates fine (Using reportnet function to cast) Cast([Datasource].[QuerySubject].[Field], char) + '%', but, when I run the report, I get an error that complains the string has been right-truncated.

What is the error you are getting?

Title: Re: how to concatenate % or $ with Procedure column
Post by: mrcool on 23 Jan 2006 06:01:21 AM

hi

this is the error getting

QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-239'.
UDA-EE-0094 The operation "add" is invalid for the following combination of data types: "double" and "character" UDA-EE-0094 The operation "add" is invalid for the following combination of data types: "double" and "character" UDA-SQL-0460 A general exception has occurred during local processing.
Is it a bug in Report net

it is coming only for procedure column.

thanks
s

Title: Re: how to concatenate % or $ with Procedure column
Post by: JoeBass on 23 Jan 2006 06:51:15 AM

It is complaining about the difference in data types.Ã,Â Have you tried casting the number as a string?Ã,Â

Title: Re: how to concatenate % or $ with Procedure column
Post by: mrcool on 23 Jan 2006 07:05:48 AM

hi

this is the error when Iam using cast function...Iam getting this error only while running the report,not when validating...Report is getting validated without errors...

UDA-EE-0092 Data exception occurred. String data has been right truncated.

UDA-SQL-0460 A general exception has occurred during local processing.

UDA-CUR-0000 Unable to fetch the row.

RSV-SRV-0025 Unable to execute this request.

Trace back:

WPBIBusMethod.cpp(190): QSException: CCL_CAUGHT: WPBIBusMethod::run

WPReportExecutionMethod.cpp(180): QSException: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions

WPExecuteRequestThread.cpp(169): QSException: WPExecuteRequestThread::checkException

WPEngine.cpp(946): QSException:

WPController.cpp(263): QSException: CCL_RETHROW: WPController::executeRendering()

LWDataRetrievalEngine.cpp(785): QSException: CCL_RETHROW: LWDataRetrievalEngine::iterateResultSets

Source/QEDmResultSet.cpp(76): QSException: CCL_THROW: QE

Title: Re: how to concatenate % or $ with Procedure column
Post by: JoeBass on 23 Jan 2006 07:25:39 AM

Thats the same scenario I mentioned above. Sounds buggy.

Title: Re: how to concatenate % or $ with Procedure column
Post by: BIsrik on 23 Jan 2006 08:18:14 AM

u can't create calculation on the procedure query subject..

Srik

Title: Re: how to concatenate % or $ with Procedure column
Post by: BIsrik on 23 Jan 2006 08:19:53 AM

Refer page 15 of Frame work manager user guide...

Srik

Title: Re: how to concatenate % or $ with Procedure column
Post by: aamuktha on 23 Jan 2006 09:57:16 PM

hi

Thanks for your reply

aamuktha

Title: Re: how to concatenate % or $ with Procedure column
Post by: BIsrik on 23 Jan 2006 11:28:12 PM

can u plz update the status of the topic..

Srik

Title: Re: how to concatenate % or $ with Procedure column
Post by: aamuktha on 24 Jan 2006 11:02:20 PM

hi

came to know that it is not possible with procedure column.May be it is bug with cognos.But not sure...........

aamuktha

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: aamuktha on 12 Jan 2006 01:25:24 AM