Indicadores - Productividad de Enfriadores
SELECT NON EMPTY { [Measures].[# Enfriadores],[Measures].[Ingreso vs. V.E.] } ON COLUMNS,
NON EMPTY { [Supervisores].[Supervisor].[Supervisor].ALLMEMBERS } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM ( SELECT ( { [Meses].[Mes].&[08] } ) ON COLUMNS
FROM ( SELECT ( { [Meses].[Año].&[2017] } ) ON COLUMNS
FROM [Model]))
WHERE ( [Meses].[Año].&[2017], [Meses].[Mes].&[08] )
SELECT NON EMPTY { [Measures].[# Enfriadores],[Measures].[# Enfriadores Secos], [Measures].[Ingreso vs. V.E.] } ON COLUMNS,
NON EMPTY { ([Supervisores].[Supervisor].[Supervisor].ALLMEMBERS * [Clientes].[Cuc].[Cuc].ALLMEMBERS * [Clientes].[Cliente].[Cliente].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM ( SELECT ( { [Meses].[Mes].&[08] } ) ON COLUMNS
FROM ( SELECT ( { [Meses].[Año].&[2017] } ) ON COLUMNS
FROM [Model]))
WHERE ( [Meses].[Año].&[2017], [Meses].[Mes].&[08] )