Reporting Services can accept any valid MDX statement. You can let the users enter freeform MDX statements by enabling the QueryTextVisible property which will display for users the Query Text window bellow the control.
SF MDX parser now supports:
· MDX comments - Following comment styles are supported: "/* */", "--", "//". However, comments are not preserved during IO operation.
· MDX sentences with ON ROWS (or Axis(1)) expression preceding ON COLUMNS (or Axis(1)) expression.
· MDX key words as substrings of member names - For example, "With Member Time.MySELECT...". Also MDX key words doesn't have to be separated by spaces any more. For example: "Select[Time].Members..." ...is a regular MDX expression for Snowflake
Explicit "NON EMPTY" expressions in MDX statement are preserved no matter of NonEmptyOnly property.
See Also Query Editor
|