IBM Support

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

Subscribe

You can track all active APARs for this component.

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 number

    PI95826

  • Reported component name

    COG REPORT STUD

  • Reported component ID

    5724W12RS

  • Reported release

    B09

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-03-27

  • Closed date

    2019-07-09

  • Last modified date

    2019-07-09

  • 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



Document information

More support for: Cognos Analytics
Report Authoring v11x

Software version: B09

Reference #: PI95826

Modified date: 09 July 2019