mysql - FOR 函数导致兼容性问题，寻找 FOR 函数的替代方案

Question

我在 Cognos 11 report Studio 中使用 DQM 包。我有两个查询，它们被连接起来进行第三个查询。在第三个查询中，我使用过滤条件作为

[Cardex].[Transaction Date] = maximum( [Cardex].[Transaction Date] for [Cardex].[Lot/Serial Number])

如果我禁用此过滤器，我的报告将运行并显示数据。但如果我将其设为必需(这是我们的要求)，则报告会抛出错误:

XQE-GEN-0018 Query Service internal error has occurred, please see the log for details.

是否有任何其他方法来定义此过滤条件？

[Cardex].[Transaction Date] = maximum( [Cardex].[Transaction Date] for [Cardex].[Lot/Serial Number])

我应该在哪里使用 FOR 函数并使用任何其他兼容函数

    Failure XQE-GEN-0018 Query Service internal error has occurred, please see the log for details. 
    10.100.190.127:9300 20948   2019-12-07 11:48:24.520 -5                  
    Default Executor-thread-3209    caf 2047    1   Audit.dispatcher.caf Request    Failure     SecureErrorId: 2019-12-07-11:48:24.520-#251  
    Original Error: XQE-GEN-0018 Query Service internal error has occurred, please see the log for details. 
    RSV-SRV-0042 Trace back:  RSReportService.cpp(764): XQEException: CCL_CAUGHT: RSReportService::processImpl()  
    RSReportServiceMethod.cpp(254): XQEException: CCL_RETHROW: 
    RSReportServiceMethod::process(): asynchRunSpecification_Request  
    RSASyncExecutionThread.cpp(887): XQEException: RSASyncExecutionThread::checkException  
    RSASyncExecutionThread.cpp(331): XQEException: CCL_CAUGHT: 
    RSASyncExecutionThread::runImpl(): asynchRunSpecification_Request  
    RSASyncExecutionThread.cpp(932): XQEException: CCL_RETHROW: 
    RSASyncExecutionThread::processCommand(): asynchRunSpecification_Request  
    Execution/RSRenderExecution.cpp(582): XQEException: CCL_RETHROW: RSRenderExecution::execute 
    Assembly/RSDocAssemblyDispatch.cpp(339): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly 
    Assembly/RSLayoutAssembly.cpp(79): XQEException: CCL_RETHROW: RSLayoutAssembly::assemble  
    Assembly/RSDocAssemblyDispatch.cpp(448): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward  
    Assembly/RSReportPagesAssembly.cpp(185): XQEException: CCL_RETHROW: RSReportPagesAssembly::assemble  
    Assembly/RSDocAssemblyDispatch.cpp(384): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly  
    Assembly/RSPageAssembly.cpp(314): XQEException: CCL_RETHROW: RSPageAssembly::assemble  
    Assembly/RSDocAssemblyDispatch.cpp(384): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly  
    Assembly/RSTableRowAssembly.cpp(177): XQEException: CCL_RETHROW: RSTableRowAssembly::assemble  
    Assembly/RSDocAssemblyDispatch.cpp(384): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly  
    Assembly/RSTableCellAssembly.cpp(151): XQEException: CCL_RETHROW: RSTableCellAssembly::assemble  
    Assembly/RSDocAssemblyDispatch.cpp(448): XQEException:

Answer 1

If I disable this filter , my report runs and diplay data . But if I make it required which is our requirement , Report throws errors as XQE-GEN-0018 Query Service internal error has occurred, please see the log for details.

我根据提供的有限信息进行猜测

过滤器可能会导致连接到模型中未连接的部件

使用 Framework Manager，确保表已连接且范围正确

很可能信息水平存在差距(参见参差不齐或不平衡)这意味着如果没有过滤器，屏幕将显示初始结果(这可能没问题)

从报告方面来看，听起来添加过滤器会让我们得到不规则的数据并产生错误

这是一个有助于理解这一点的链接 https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.2.doc/c_cr_rptstd_wrkdat_ragged_hierarchies.html

要进行故障排除，请使用非常小的结果集构建模型的简单版本，您知道该结果集是平衡且定义良好的然后尝试您的报告

如果它没有产生错误 - 这不是报告，而是模型

请告诉我，我们可以采取下一步