MDX查询：[Simple Cube]的语法不正确(MDX Query: The Syntax for [Simple Cube] is incorrect)

 我很确定这是一个语法错误，但我不熟悉MDX。 任何帮助将不胜感激。 我不断收到错误“Parser：[Simple Cube]的语法不正确。我使用的度量[Cancel Disbursement Amount]，返回三个不同的值。我试图选择[Dim Disbursement Type ]等于AGENT COMMISSION。这里是查询： 
 
    SELECT NON EMPTY { [Measures].[Cancel Disbursement Amount] } 
    ON COLUMNS, NON EMPTY { [Dim Disbursement Type].[Description].&[AGENT 
    COMMISSION]} 
    ON COLUMNS FROM ([Simple Cube])
    CELL PROPERTIES VALUE, BACK_COLOR, 
    FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME,  FONT_SIZE, FONT_FLAGS
 
 谢谢！ 

I'm pretty sure this is a syntax error, but I'm unfamiliar with MDX. Any help would be greatly appreciated. I keep getting the error "Parser: the syntax for [Simple Cube] in incorrect. The measure I'm using, [Cancel Disbursement Amount], returns three different values. I'm trying to select the value where the [Dim Disbursement Type] equals AGENT COMMISSION. Here's the query:
 
    SELECT NON EMPTY { [Measures].[Cancel Disbursement Amount] } 
    ON COLUMNS, NON EMPTY { [Dim Disbursement Type].[Description].&[AGENT 
    COMMISSION]} 
    ON COLUMNS FROM ([Simple Cube])
    CELL PROPERTIES VALUE, BACK_COLOR, 
    FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME,  FONT_SIZE, FONT_FLAGS
 
Thank you!

原文：https://stackoverflow.com/questions/49278656