Hello , I am new to MDX and would like to know how to calculate average in MDX . I tried several expressions but i failed .I have a ITSM cube . I would like to calculate average of incidents per month and for a group .
Number of incident = [Measures].[Nombre incidents]
Per month = [Date création].[Mois]
Organised by the group = [Groupe affecté - Historique].[Groupe affecté].&[N1-Hotline]
I am using SSRS . Thanks .
Regards .
My actual MDX is (without average calculation) :
SELECT NON EMPTY { [Measures].[Nombre incidents] } ON COLUMNS, NON EMPTY { ([Date création].[Mois].[Mois].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Date création].[Année].&[2012] } ) ON COLUMNS
FROM ( SELECT ( { [Groupe affecté - Historique].[Groupe affecté].&[N1-Hotline] } ) ON COLUMNS FROM [Incidents])) WHERE ( [Groupe affecté - Historique].[Groupe affecté].&[N1-Hotline], [Date création].[Année].&[2012] ) CELL PROPERTIES VALUE, BACK_COLOR,
FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
