WITH
MEMBER [Measures].[TotalSortie] AS
Sum(
({Descendants(
[TEMPS].[ANNEE - SEMESTRE - TRIMESTRE - MOIS - DATE - JOURFERIE - WEEKEND - JOUROUVRE].CurrentMember
,[TEMPS].[DATE])}
,{[TYPE ENTREE SORTIE].[TYPE ENTREE SORTIE].&[Sortie]}
)
, [Measures].[TF ENTREE SORTIE Count]
)
MEMBER [Measures].[TotalPersFinDeMois] as
Sum(
Descendants(
[TEMPS].[ANNEE - SEMESTRE - TRIMESTRE - MOIS - DATE - JOURFERIE - WEEKEND - JOUROUVRE].NextMember
,[TEMPS].[DATE])
, [Measures].[Effectif Global]
)
MEMBER [Measures].[PourcTurnOver] as
Round( [Measures].[TotalSortie] * 100 / [Measures].[TotalPersFinDeMois], 2 )
select
{[Measures].[TotalSortie], [Measures].[TotalPersFinDeMois], [Measures].[PourcTurnOver] } on 0,
([TEMPS].[Annee].[Annee],[TEMPS].[Mois Annee].[Mois Annee]) on 1
from [RH]
Partager