1 2 3 4 5 6
| WITH
MEMBER [Measures].[MT LIQ HORS COM] AS sum([Measures].[MNT HT LIG MAN HORS COM],[Measures].[MNT HT LIG LIQ HORS COM])
MEMBER [Measures].[MT LIQ COM] AS sum([Measures].[MNT HT LIG MAN COM],[Measures].[MNT HT LIG LIQ COM])
SELECT NON EMPTY { [Measures].[MT LIQ HORS COM], [Measures].[MT LIQ COM],[Measures].[MNT HT LIG MAN HORS COM], [Measures].[MNT HT LIG LIQ COM], [Measures].[MNT HT LIG MAN COM], [Measures].[MNT HT LIG LIQ HORS COM]} ON COLUMNS,
NON EMPTY {([Date de liquidation - Mandat].[DATE].[DATE].ALLMEMBERS * [Dim Mandat].[NUMERO].[NUMERO].ALLMEMBERS ) } ON ROWS
FROM [Win M9DW] |
Partager