我有以下 MDX 查询,它在执行时成功返回度量 -
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”添加到查询的开头,则会返回以下错误 -
钻取失败,因为 SELECT 子句标识的坐标超出范围。
有人可以帮忙吗?
当您在“选择”中具有相同维度的多个成员时(在本例中是在切片器维度上),看起来 MDX 不喜欢 DRILLTHROUGH。看来您还可以通过进行子选择来欺骗它,但在依赖此解决方案之前我会非常仔细地验证总数。
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)
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)