Getting error while viewing tabular data in cognos10

[inu]

Hi Team,

When i try to view tabular data for one query item which contains the expression as follows:

IF ([Business Layer].[Place of payment].[Department Code] = 'HO' ) THEN
    (52)
ELSE
    ( to_number([Business Layer].[Place of payment].[Department Code]) )

I get error says

UDA-SQL-0107 A general exception has occurred during the operation "open result".ORA-01722: invalid number
RSV-SRV-0042 Trace back:RSReportService.cpp(726): QFException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(259): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(854): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(311): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(910): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestRSRequest.cpp(1697): QFException: CCL_THROW: RSRequest::executeInteractivePrompting()RSQueryMgr.cpp(520): QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(587): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(679): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgrBasic.cpp(289): QFException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrBasic.cpp(278): QFException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(175): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(166): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()QFSSession.cpp(1153): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1151): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1108): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1084): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(800): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(4484): QFException: CCL_THROW: CoordinationPlanner

Please suggest me guys , where is mistake.

Regards
Inam

[R Ambre]

Hi,

Looking at your code ([Business Layer].[Place of payment].[Department Code] = 'HO' )
[Business Layer].[Place of payment].[Department Code]  contains alphabetical value and you are trying to convert that to number ..may be because of that you are getting an error.

[bvk.cognoise]

Hi Inu,

Please use following expression


IF ([Business Layer].[Place of payment].[Department Code] = 'HO' ) THEN
    ('52')
ELSE
    ( to_number([Business Layer].[Place of payment].[Department Code]) )

Regards
Bvk

[inu]

Hi Inu,

Please use following expression


IF ([Business Layer].[Place of payment].[Department Code] = 'HO' ) THEN
    ('52')
ELSE
    ( to_number([Business Layer].[Place of payment].[Department Code]) )

Regards
Bvk

Hi Bvk,

Nice catch, I appreciate . I did same thing.