Invalid coercion from 'memberSet' to 'member, measure' for '[Regions]' in 'set([

[tarunkrdas2013]

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

[MFGF]

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.

[tarunkrdas2013]

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])'.

[MFGF]

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

[tarunkrdas2013]

Yeah its a typo

Expression for BOD
[Hierarchical].[Company].[Location].[Division]->[all].[1].[BD]

Expression for Core
aggregate( currentMeasure within set [Regions])

[tarunkrdas2013]

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

[MFGF]

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.

[tarunkrdas2013]

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

[MFGF]

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.