Home > database >  Sapbw MDX how to write not in or under the condition of <>.
Sapbw MDX how to write not in or under the condition of <>.

Time:09-23

Sapbw740 environment, with the aid of fineReport 8 generates MDX statement.
A. is not equal to the generated under the condition of MDX:
With member [ZSCUSTMR] [LEVEL00] x100 as Aggregate ([ZSCUSTMR]. [LEVEL00] - [ZSCUSTMR] [LEVEL00] - 01 [C]) select {ZSPRICE, ZSQTY} on the columns, {[[ZSPRODCT]]. [LEVEL1]] Members} on rows from $ZSSA_C01 where ([ZSCUSTMR]. [LEVEL00] x100)
B. don't contain the generated under the condition of MDX:
With member [ZSCUSTMR] [LEVEL00] x102 as Aggregate ({[ZSCUSTMR]. [LEVEL00] Members} - {[ZSCUSTMR]. [LEVEL00] - 01 [C]}) select {ZSPRICE, ZSQTY} on the columns, {[[ZSPRODCT]]. [LEVEL1]] Members} on rows from $ZSSA_C01 where ([ZSCUSTMR]. [LEVEL00] x102)

Grammar testing under the mdxtest has problem, how did you write this under sapbw MDX?

With member [ZSCUSTMR] x101 as Aggregate ({[ZSCUSTMR]. Members - [ZSCUSTMR] - 01 [C]})
Select {[Measures]. ZSPRICE, [Measures] ZSQTY} on the columns, Non Empty {[ZSPRODCT]. [LEVEL01] Members} on rows
The from [$ZSSA_C01] where [ZSCUSTMR] x101
The MDX statement plus the where conditions are reported: Invalid MDX command with & lt; Num_val & gt; - & lt; Num_val & gt; Error,
Or where there are special SAP MDX grammar reference documentation

  • Related