sapbw下的mdx怎么写not in或<>条件.
sapbw740环境下,借助fineReport 8生成mdx语句.
A. 不等于条件下生成的mdx:
with member [ZSCUSTMR].[LEVEL00].x100 as Aggregate ([ZSCUSTMR].[LEVEL00]-[ZSCUSTMR].[LEVEL00].[C-01]) select {ZSPRICE,ZSQTY} on columns, {[[ZSPRODCT]].[LEVEL1]].Members} on rows from $ZSSA_C01 where ([ZSCUSTMR].[LEVEL00].x100)
B. 不包含于条件下生成的mdx:
with member [ZSCUSTMR].[LEVEL00].x102 as Aggregate ({[ZSCUSTMR].[LEVEL00].Members}-{[ZSCUSTMR].[LEVEL00].[C-01]} ) select {ZSPRICE,ZSQTY} on columns, {[[ZSPRODCT]].[LEVEL1]].Members} on rows from $ZSSA_C01 where ([ZSCUSTMR].[LEVEL00].x102)
在mdxtest下进行语法检测都有问题,这个在sapbw下的mdx是怎么写的?
with member [ZSCUSTMR].x101 as Aggregate ({[ZSCUSTMR].Members-[ZSCUSTMR].[C-01]})
select {[Measures].ZSPRICE,[Measures].ZSQTY} on columns, Non Empty{[ZSPRODCT].[LEVEL01].Members} on rows
from [$ZSSA_C01] where [ZSCUSTMR].x101
这个mdx语句加上where条件则报:Invalid MDX command with <num_val> - <num_val>错误。
或哪里有专门的sap mdx语法说明文档参考