gistfile1.txt

WITH
SET [~ROWS_combined_combined.combined] AS
    Hierarchize({{[combined].[loc].Members}, {[combined].[pct].Members}})
SET [~ROWS_othercombined_othercombined.otherhierarchy] AS
    {[othercombined.otherhierarchy].[ref2].Members}
MEMBER [Measures].[test] as '(([Measures].[count_consultations], [combined].[All combineds], [ccg.H0].[All ccg.H0s]))/(([Measures].[count_consultations], [combined].[All combineds], [othercombined.otherhierarchy].[All othercombined.otherhierarchys]))'
MEMBER [Measures].[other1] as '(([Measures].[count_consultations], [combined].[All combineds], [ccg.H0].[All ccg.H0s]))'
MEMBER [Measures].[other] as '(([Measures].[count_consultations], [combined].[All combineds], [othercombined.otherhierarchy].[All othercombined.otherhierarchys]))'
SELECT
NON EMPTY {[Measures].[count_consultations],[Measures].[test], [Measures].[other1], [Measures].[other]} ON COLUMNS,
NON EMPTY NonEmptyCrossJoin([~ROWS_combined_combined.combined], [~ROWS_othercombined_othercombined.otherhierarchy]) ON ROWS
FROM [MEC]