Hi Everyone,
I created filter [tuple(a1, b1)<>0 or tuple(a2,b2)<>0] for zero supression and when I run the report it is giving me the following error.
PCA-ERR-0064
The tuple operator is not applicable. The hierarchy of member [MEASURES]..[Sales Target] is already in the tuple.
RSV-SRV-0042 Trace back:RSReportService.cpp(758): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(252): QFException: CCL_RETHROW: RSReportServiceMethod::process(): promptPagingForward_RequestRSASyncExecutionThread.cpp(774): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(211): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): promptPagingForward_RequestRSASyncExecutionThread.cpp(824): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_RequestExecution/RSRenderExecution.cpp(593): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(264): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(64): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(331): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(163): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageSetAssembly.cpp(401): QFException: CCL_RETHROW: RSPageSetAssembly::assembleAssembly/RSAssembly.cpp(626): QFException: CCL_RETHROW: RSAssembly::createListIteratorAssembly/RSAssembly.cpp(667): QFException: CCL_RETHROW: RSAssembly::createListIteratorRSQueryMgr.cpp(989): QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(1062): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(1227): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgr.cpp(1527): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1514): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(174): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(154): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQFSession.cpp(251): QFException: CCL_RETHROW: RSQFSession::DoRequestQFSSession.cpp(702): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(700): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(645): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(620): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(737): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(199): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(4178): QFException: CCL_THROW: CoordinationPlanner
Can anyone please explain me y I am getting this error.
Thanks in Advance,
Anu.
Hi,
You don't specify how A1, B1, A2 and B2 are currently defined. It also looks like you are mixing dimensional (tuples) and relational (detail filter) reporting techniques, which is strongly discouraged.
MF.