1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| WITH MEMBER [Measures].[Montant Au Px Vente m-1] AS
(
ParallelPeriod([Time].[Année - Mois - Date].[Mois],1,[Time].[Année - Mois - Date].[Année].[2015])
,[Measures].[Montant Au Px Vente]
)
SELECT
NON EMPTY {
[Measures].[Montant Au Px Vente],
[Measures].[Montant Au Px Vente m-1]
} ON COLUMNS,
NON EMPTY { (
[Time].[Année - Mois - Date].[Mois].ALLMEMBERS
) } ON ROWS
FROM ( SELECT ( { [Stat Facture All].[Service 2].&[EXPORT], [Stat Facture All].[Service 2].&[GASTRO], [Stat Facture All].[Service 2].&[GMS], [Stat Facture All].[Service 2].&[RETAIL], [Stat Facture All].[Service 2].&[TRAD Autriche] } ) ON COLUMNS
FROM ( SELECT ( { [Stat Facture All].[Société].&[DF] } ) ON COLUMNS
FROM ( SELECT ( { [Time].[Année - Mois - Date].[Année].[2015]} ) ON COLUMNS
FROM [factures])))
WHERE ( [Stat Facture All].[Société].&[DF], [Stat Facture All].[Service 2].CurrentMember ) |
Partager