Error in report studio when I use a tuple as a filter

[anuhya201]

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.

[MFGF]

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.