PI95826: WRONG MDX IS GENERATED FOR SSAS CUBE WHEN DRAGGING AN ITEM AS A PAGE LAYER GIVING A XQE-CON-0007 ERROR.

APAR status

• Closed as fixed if next.

Error description

• XQE-CON-0007 XQE error encountered: XOD-DAT-0001 Query execution
  failed. The underlying data provider returned an error:
  ERROR
  [category=OLEDB_API,statusCode=-2147467259,causeCode=-1056047102
  ,source=CODBOWrapper::Execute(CNativeEnv&, m_pICommand,
  NULL,IID_IMDDataset,NULL,NULL,m_pIMDDataset) at
  CODBOResultSet::Execute(CNativeEnv& cnativeEnv) at
  CODBOConnection::Execute(CNativeEnv& cnativeEnv, const
  CODBOResultSet* pResultSet) at
  Java_com_cognos_xqe_data_providers_olap_odbo_ODBOConnection_cExe
  cuteMDX]: Query (3, 60) Parser: The syntax for ')' is incorrect.
  (WITH
    MEMBER [RADAR PLANT].[PLANT TYPE].[XQE_SL_CM3] AS ([RADAR
  PLANT].[PLANT TYPE].&[Operations])
    MEMBER [RADAR PLANT].[RADAR PLANT NAME].[XQE_SL_CM2] AS ()
    MEMBER [PL CATEGORY].[PL Hierarchy].[XQE_V5M_CM1] AS
  AGGREGATE([PL CATEGORY].[PL Hierarchy].[PL LEVEL 1].MEMBERS),
  SOLVE_ORDER = 8, CAPTION = 'Summary'
    MEMBER [DATE].[Calendar Hierarchy].[XQE_V5M_CM0] AS
  AGGREGATE([DATE].[Calendar Hierarchy].[YEAR].MEMBERS),
  SOLVE_ORDER = 4, CAPTION = 'Summary'
  SELECT
    NON EMPTY {[DATE].[Calendar Hierarchy].[YEAR].MEMBERS,
  [DATE].[Calendar Hierarchy].[XQE_V5M_CM0]} DIMENSION PROPERTIES
  PARENT_LEVEL,  PARENT_UNIQUE_NAME ON AXIS(0),
    NON EMPTY {[PL CATEGORY].[PL Hierarchy].[PL LEVEL 5].MEMBERS,
  [PL CATEGORY].[PL Hierarchy].[XQE_V5M_CM1]} DIMENSION PROPERTIES
  PARENT_LEVEL,  PARENT_UNIQUE_NAME ON AXIS(1),
    {[Measures].[GL AMOUNT (M)]} DIMENSION PROPERTIES
  PARENT_LEVEL,  PARENT_UNIQUE_NAME ON AXIS(2)
  FROM [RADAR]
  WHERE ([RADAR PLANT].[RADAR PLANT NAME].[XQE_SL_CM2], [RADAR
  PLANT].[PLANT TYPE].[XQE_SL_CM3], [RADAR CATEGORY].[RADAR
  CATEGORY NAME].&[GL-Income Statement]) CELL PROPERTIES
  CELL_ORDINAL,  FORMAT_STRING,  LANGUAGE,  VALUE).
  RSV-SRV-0042 Trace back:
  RSReportService.cpp(766): XQEException: CCL_CAUGHT:
  RSReportService::processImpl()
  RSReportServiceMethod.cpp(253): XQEException: CCL_RETHROW:
  RSReportServiceMethod::process(): asynchRun_Request
  RSASyncExecutionThread.cpp(873): XQEException:
  RSASyncExecutionThread::checkException
  RSASyncExecutionThread.cpp(317): XQEException: CCL_CAUGHT:
  RSASyncExecutionThread::runImpl(): asynchRun_Request
  RSASyncExecutionThread.cpp(918): XQEException: CCL_RETHROW:
  RSASyncExecutionThread::processCommand(): asynchRun_Request
  Execution/RSRenderExecution.cpp(582): XQEException: CCL_RETHROW:
  RSRenderExecution::execute
  Assembly/RSDocAssemblyDispatch.cpp(346): XQEException:
  CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
  Assembly/RSLayoutAssembly.cpp(79): XQEException: CCL_RETHROW:
  RSLayoutAssembly::assemble
  Assembly/RSDocAssemblyDispatch.cpp(455): XQEException:
  CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
  Assembly/RSReportPagesAssembly.cpp(185): XQEException:
  CCL_RETHROW: RSReportPagesAssembly::assemble
  Assembly/RSDocAssemblyDispatch.cpp(391): XQEException:
  CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
  Assembly/RSPageSetAssembly.cpp(474): XQEException: CCL_RETHROW:
  RSPageSetAssembly::assemble
  Assembly/RSDocAssemblyDispatch.cpp(391): XQEException:
  CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
  Assembly/RSPageGroupAssembly.cpp(526): XQEException:
  CCL_RETHROW: RSPageSetAssembly::assemble
  Assembly/RSDocAssemblyDispatch.cpp(391): XQEException:
  CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
  Assembly/RSPageAssembly.cpp(314): XQEException: CCL_RETHROW:
  RSPageAssembly::assemble
  Assembly/RSDocAssemblyDispatch.cpp(391): XQEException:
  CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
  Assembly/RSTableRowAssembly.cpp(177): XQEException: CCL_RETHROW:
  RSTableRowAssembly::assemble
  Assembly/RSDocAssemblyDispatch.cpp(391): XQEException:
  CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
  Assembly/RSTableCellAssembly.cpp(151): XQEException:
  CCL_RETHROW: RSTableCellAssembly::assemble
  Assembly/RSDocAssemblyDispatch.cpp(455): XQEException:
  CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
  Assembly/RSDocAssemblyDispatch.cpp(391): XQEException:
  CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
  RSResultSetIterator.cpp(1515): XQEException: CCL_RETHROW:
  RSResultSetIterator::retrieveData
  QFSMasterDataset.cpp(278): XQEException: CCL_RETHROW:
  QFSMasterDataset::GetPartialDataset
  XQEConnector.cpp(300): XQEException: CCL_THROW:
  XQEConnector::send
  

Local fix

• Use Section/Unsection -> Set page break using master/detail.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.1.3                       *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels