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語法說明檔案參考
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/68502.html
標籤：數據倉庫
上一篇：有誰能給一份報表需求書模板嗎？
下一篇：mysql資料庫