我尝试运行以下查询,但出现错误
解析器:由于歧义,无法解析语句方言。
WITH MEMber [Measures].[Test] AS
SUM({[Item Dimension].[DivCode]},{[Item Dimension].[ItemCode].Allmembers},[Measures].[Stock Qty],[Measures].[Sales Qty])
SELECT
{[Item Dimension].[DivCode]},{[Item Dimension].[ItemCode].Allmembers} ON ROWS,[Measures].[Sales Qty] ON COLUMNS
FROM dbCube
有帮助吗?