cbobadillavega
9/12/2017 - 8:58 PM

Indicadores - Productividad de Enfriadores

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] )