I have the following MDX query using a subquery approach ...

SELECT
NON EMPTY {{[Measures].[totalpayments]}} ON COLUMNS,
NON EMPTY {[organization_masterentity.bemaster].[master].Members} ON ROWS
FROM (Select ({[organization_masterentity.bemaster].[master].&[1]}) ON COLUMNS
FROM [opsCharges_Rev001_cub])

The syntax is correct, however I keep getting the following bracket error:

MondrianException: Mondrian Error:Syntax error at line 4, column 6, token '('

Does this means that Mondrian doesn't support subqueries??

Thanks!!