MDX DRILLTHROUGH失败，但是可以成功执行选择 [英] MDX DRILLTHROUGH Fails but select can be successfully executed

问题描述

我有以下MDX查询，该查询在执行时成功返回度量-

I have the following MDX query which succesfully returns the measure when executed -

SELECT  
{[Measures].[Closed Quote OE Retail]} ON COLUMNS 
FROM Sales
WHERE
(
[Posting Date].[Date YQMD].[Month].&[11]&[2012]
,[Work Provider].[Code].[LV]
,EXCEPT([Item].[by Item Category by Product Group].[Item Category], [Item].[by Item Category by Product Group].[Item Category].&[OEM])
,EXCEPT([Lost Sale Reason Code].[Code].[Code], [Lost Sale Reason Code].[Code].[All Lost Sale Reason Code].UNKNOWNMEMBER)
,EXCEPT([Lost Sale Reason Code].[by MI Type].[MI Type], { [Lost Sale Reason Code].[by MI Type].[MI Type].&[Not Justified] })
)

但是，如果我在查询的开头添加"DRILLTHROUGH"，则会返回以下错误-

But if I add 'DRILLTHROUGH' to the start of the query the following error is returned -

钻取失败，因为SELECT子句标识的坐标超出范围.

Drillthrough failed because the coordinate identified by the SELECT clause is out of range.

任何人都可以帮忙吗?

推荐答案

当Select中有多个相同维度的成员时，MDX不喜欢DRILLTHROUGH(在这种情况下，是在切片器维度上).看来您也可以通过子选择来欺骗它，但是在依靠此解决方案之前，我会非常仔细地验证总数.

Looks like MDX doesn't like DRILLTHROUGH when you have multiple members of the same dimension in the Select - in this case, on your slicer dimension. It also appears you can trick it by doing a sub-select, but I would verify the totals pretty carefully before relying on this solution.

SELECT  
{[Measures].[Closed Quote OE Retail]} ON COLUMNS 
FROM 
(
  Select 
  (
    [Posting Date].[Date YQMD].[Month].&[11]&[2012]
    ,[Work Provider].[Code].[LV]
    ,EXCEPT([Item].[by Item Category by Product Group].[Item Category], 
      [Item].[by Item Category by Product Group].[Item Category].&[OEM])
    ,EXCEPT([Lost Sale Reason Code].[Code].[Code], 
      [Lost Sale Reason Code].[Code].[All Lost Sale Reason Code].UNKNOWNMEMBER)
    ,EXCEPT([Lost Sale Reason Code].[by MI Type].[MI Type], 
      { [Lost Sale Reason Code].[by MI Type].[MI Type].&[Not Justified] }
  ) on 0
From Sales)

这篇关于MDX DRILLTHROUGH失败，但是可以成功执行选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！