My Report is a DMR and when trying to Run the Report getting below error
Invalid coercion from 'memberSet' to 'member, measure' for '[Regions]' in 'set([Regions],[BOD],[Core])'.
This is the expression of [Regions]
set(
[Hierarchical].[Company].[Location].[Region]->[all].[1].[N].[BA],[Hierarchical].[Company].[Location].[Region]->[all].[1].[N].[MW],[Hierarchical].[Company].[Location].[Region]->[all].[1].[N].[NW],[Hierarchical].[Company].[Location].[Region]->[all].[1]..[LA],[Hierarchical].[Company].[Location].[Region]->[all].[1]..[SD],[Hierarchical].[Company].[Location].[Region]->[all].[1].[E].[NE],[Hierarchical].[Company].[Location].[Region]->[all].[1].[E].[SE])
I know its difficult to suggest without seeing the report but trying my luck
Quote from: tarunkrdas2013 on 01 Sep 2015 11:38:29 AM
My Report is a DMR and when trying to Run the Report getting below error
Invalid coercion from 'memberSet' to 'member, measure' for '[Regions]' in 'set([Regions],[BOD],[Core])'.
This is the expression of [Regions]
set(
[Hierarchical].[Company].[Location].[Region]->[all].[1].[N].[BA],[Hierarchical].[Company].[Location].[Region]->[all].[1].[N].[MW],[Hierarchical].[Company].[Location].[Region]->[all].[1].[N].[NW],[Hierarchical].[Company].[Location].[Region]->[all].[1]..[LA],[Hierarchical].[Company].[Location].[Region]->[all].[1]..[SD],[Hierarchical].[Company].[Location].[Region]->[all].[1].[E].[NE],[Hierarchical].[Company].[Location].[Region]->[all].[1].[E].[SE])
I know its difficult to suggest without seeing the report but trying my luck
Hi,
[Regions] already appears to be a set, and you can't use a set in place of a member within a set() function. What is your requirement - is it to add the [BOD] and [CORE] members to the same set? If so, try union([Regions],[BOD],[Core]) - this assumes that [BOD] and [Core] are members or sets from the same hierarchy.
Cheers!
MF.
Thank you for clarification..really appreciated..Yes my requirement is to add these
I tried with this using union([Regions],[BOD],[Core] ,got below parsing error
Parsing error before or near position: 29 of: "union([Regions],[BOD],[Core]"
Alternatively i tried union(union([Regions],[BOD]),[Core]) ,got below error
Invalid coercion from 'value' to 'memberSet' for '[Core]' in 'union(union([Regions],set([BOD])),[Core])'.
Hi,
You need to tell us what BOD and Core are. Also, the first Union expression you posted appears to be missing the final close parenthesis at the end - is this a typo?
MF.
Sent from my iPhone using Tapatalk
Yeah its a typo
Expression for BOD
[Hierarchical].[Company].[Location].[Division]->[all].[1].[BD]
Expression for Core
aggregate( currentMeasure within set [Regions])
When i run tabular data for individual BOD and Core,they give output but when i put them in Union they throw invalid coercion error
Quote from: tarunkrdas2013 on 02 Sep 2015 10:47:47 AM
Yeah its a typo
Expression for BOD
[Hierarchical].[Company].[Location].[Division]->[all].[1].[BD]
Expression for Core
aggregate( currentMeasure within set [Regions])
Hi,
BOD looks fine - it's the MUN of a member - but Core is your issue here. Using the aggregate() function makes the result a value, not a member. Is there a reason you are using this approach for Core rather than simply bringing in the All Regions member?
MF.
Change the expression of Core to [Regions] when i ran the report ..below error came which is difficult to understand
The report server encountered an internal error. Check additional information associated with this error message. If cause of problem cannot be ascertained, increase the logging level in the IBM Cognos administration tool and reproduce the conditions that caused the error. If the problem persists, see the problem determination information on the IBM Cognos Support Portal page at http://www-947.ibm.com/support/entry/portal/Overview/Software/Information_Management/Cognos_Business_Intelligence.
Details Expand
CCLOutOfMemoryError:0:Fatal: RSV-SRV-0042 Trace back:RSReportService.cpp(738): CCLOutOfMemoryError: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(258): CCLOutOfMemoryError: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(859): CCLOutOfMemoryError: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(314): CCLOutOfMemoryError: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): promptPagingForward_RequestRSASyncExecutionThread.cpp(904): CCLOutOfMemoryError: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_RequestExecution/RSRenderExecution.cpp(600): CCLOutOfMemoryError: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(340): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): CCLOutOfMemoryError: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(446): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(185): CCLOutOfMemoryError: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(314): CCLOutOfMemoryError: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(177): CCLOutOfMemoryError: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): CCLOutOfMemoryError: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(446): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(384): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyRSQueryMgr.cpp(636): CCLOutOfMemoryError: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(744): CCLOutOfMemoryError: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgrBasic.cpp(289): CCLOutOfMemoryError: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(174): CCLOutOfMemoryError: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()QFSSession.cpp(1169): CCLOutOfMemoryError: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1167): CCLOutOfMemoryError: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1118): CCLOutOfMemoryError
Quote from: tarunkrdas2013 on 03 Sep 2015 12:33:45 PM
Change the expression of Core to [Regions] when i ran the report ..below error came which is difficult to understand
The report server encountered an internal error. Check additional information associated with this error message. If cause of problem cannot be ascertained, increase the logging level in the IBM Cognos administration tool and reproduce the conditions that caused the error. If the problem persists, see the problem determination information on the IBM Cognos Support Portal page at http://www-947.ibm.com/support/entry/portal/Overview/Software/Information_Management/Cognos_Business_Intelligence.
Details Expand
CCLOutOfMemoryError:0:Fatal: RSV-SRV-0042 Trace back:RSReportService.cpp(738): CCLOutOfMemoryError: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(258): CCLOutOfMemoryError: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(859): CCLOutOfMemoryError: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(314): CCLOutOfMemoryError: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): promptPagingForward_RequestRSASyncExecutionThread.cpp(904): CCLOutOfMemoryError: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_RequestExecution/RSRenderExecution.cpp(600): CCLOutOfMemoryError: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(340): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): CCLOutOfMemoryError: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(446): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(185): CCLOutOfMemoryError: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(314): CCLOutOfMemoryError: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(177): CCLOutOfMemoryError: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): CCLOutOfMemoryError: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(446): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(384): CCLOutOfMemoryError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyRSQueryMgr.cpp(636): CCLOutOfMemoryError: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(744): CCLOutOfMemoryError: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgrBasic.cpp(289): CCLOutOfMemoryError: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(174): CCLOutOfMemoryError: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()QFSSession.cpp(1169): CCLOutOfMemoryError: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1167): CCLOutOfMemoryError: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1118): CCLOutOfMemoryError
Hi,
Why have you set Core to be [Regions] - that doesn't seem to make any sense? What happens if you change your expression to be
union([Regions],[BOD],[drag in the All Regions member from at the top of your hierarchy here])
The Error you got, by the way, means your report has probably blown the temp space available to the Cognos server:
http://www-01.ibm.com/support/docview.wss?uid=swg21430803
Cheers!
MF.