filter过滤问题又来了

我在FM里做的一个维度 车商  现在在RS里做了一个值提示 查询值就是要这个 车商维度在明细过滤那 [ids6].[车商].[车商].[车商] = ?参数2?  但运行后 选择值提示 后报错[table=98%]RQP-DEF-0177[table=98%][table=98%][td=1,1,1]    执行操...显示全部
我在FM里做的一个维度 车商  现在在RS里做了一个值提示 查询值就是要这个 车商维度在明细过滤那 [ids6].[车商].[车商].[车商] = ?参数2?  
但运行后 选择值提示 后报错
[table=98%]
RQP-DEF-0177
[table=98%]


[table=98%]
[td=1,1,1]



    执行操作“sqlPrepareWithOptions”(状态为“-16”)时出错。


[table=98%]
UDA-SQL-0358 行 15:“=”附近出现语法错误。 RSV-SRV-0042 回溯: RSReportService.cpp(747): QFException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(217): QFException: CCL_RETHROW: RSReportServiceMethod::process(): promptPagingForward_Request RSASyncExecutionThread.cpp(690): QFException: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(204): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): promptPagingForward_Request RSASyncExecutionThread.cpp(740): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_Request Execution/RSRenderExecution.cpp(570): QFException: CCL_RETHROW: RSRenderExecution::execute Assembly/RSDocAssemblyDispatch.cpp(251): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSLayoutAssembly.cpp(63): QFException: CCL_RETHROW: RSLayoutAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(317): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSReportPagesAssembly.cpp(163): QFException: CCL_RETHROW: RSReportPagesAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(268): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSPageAssembly.cpp(284): QFException: CCL_RETHROW: RSPageAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(268): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableRowAssembly.cpp(154): QFException: CCL_RETHROW: RSTableRowAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(268): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableCellAssembly.cpp(108): QFException: CCL_RETHROW: RSTableCellAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(317): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward RSQueryMgr.cpp(1019): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIterator RSQueryMgr.cpp(1165): QFException: CCL_RETHROW: RSQueryMgr::createIterator RSQueryMgr.cpp(1475): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQueryMgr.cpp(1462): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQueryMgrExecutionHandlerImpl.cpp(172): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute() RSQueryMgrExecutionHandlerImpl.cpp(164): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute() RSQFSession.cpp(241): QFException: CCL_RETHROW: RSQFSession::DoRequest QFSSession.cpp(604): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(602): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest() QFSSession.cpp(551): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSConnection.cpp(737): QFException: CCL_RETHROW: QFSConnection::Execute QFSQuery.cpp(117): QFException: CCL_RETHROW: QFSQuery::Execute v2 CoordinationQFSQuery.cpp(3775): QFException: CCL_THROW: CoordinationPlanner

求大神帮忙解答
以及报这种sql问题的解决思路

收起
参与11

查看其它 6 个回答qq274045955的回答

qq274045955qq274045955软件开发工程师中南海
回复 3# kingwang
我都值提示就是取自于这个维度啊  [ids6].[车商].[车商].[车商]
在放在参数2 里与这个维度去比较  。。现在我把 明细过滤写成   [ids6].[车商].[车商].[车商]=cast(?参数2?,varchar(20))
提示 level 与char 不能比较
互联网服务 · 2015-01-21
浏览1242

回答者

qq274045955
软件开发工程师中南海
擅长领域: 大数据cognos联机分析处理

qq274045955 最近回答过的问题

回答状态

  • 发布时间:2015-01-21
  • 关注会员:1 人
  • 回答浏览:1242
  • X社区推广