1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
|
WITH
MEMBER [Measures].[Ratio PI]
AS
Aggregate
(
{[Geographie].[Lieu].[Pays].members}
*
{[Type Activte].[Type Activite].&[1]:[Type Activte].[Type Activite].&[6]},
[Measures].[Population Sexe Age TA])
/
Aggregate
(
{
([Age].[Age].&[1]),
([Age].[Age].&[2]),
([Age].[Age].&[3])
}
*{[Geographie].[Lieu].[Pays].members}
*{[Type Activte].[Type Activite].&[1]:[Type Activte].[Type Activite].&[6]},
[Measures].[Population Sexe Age TA]
)
MEMBER [Measures].[Ratio TI] AS
Aggregate
(
{[Type Activte].[Type Activite].currentmember},
[Measures].[Population Sexe Age TA])
/
Aggregate
(
{[Type Activte].[Type Activite].&[1],[Type Activte].[Type Activite].&[2]},
[Measures].[Population Sexe Age TA]
)
MEMBER [Measures].[Taux Standardise] AS
(
[Measures].[Ratio PI]
*
[Measures].[Ratio TI]
*100
)
SELECT
{
[Measures].[Ratio PI],
[Measures].[Population Sexe Age TA],
[Measures].[Ratio TI],
[Measures].[Taux Standardise]
}
ON 0,
[Sexe].[Sexe].&[1]
*
{
([Age].[Age].&[1]),
([Age].[Age].&[2]),
([Age].[Age].&[3])
} *{[Type Activte].[Type Activite].&[1],[Type Activte].[Type Activite].&[2]}
*{[Geographie].[Lieu].[Ville].&[1001],[Geographie].[Lieu].[Ville].&[1002]}
ON 1
FROM [CUBESTAGE] |
Partager