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
| SELECT NON EMPTY {
// [Measures].[Ca Propose]
// ,[Measures].[Ca Planifie]
// ,[Measures].[Ca Realise]
// ,[Measures].[Ca Facture]
[Measures].[Proposition - Total Ca Produit HT]
, [Measures].[Proposition - Total Ca Frais HT]
, [Measures].[Proposition - Ca Produit HT Planifie]
, [Measures].[Proposition - Ca Frais HT Planifie]
, [Measures].[Proposition - Ca Produit HT Preste]
, [Measures].[Proposition - Ca Frais HT Preste]
, [Measures].[Proposition - Ca Produit HT Facture]
, [Measures].[Proposition - Ca Frais HT Facture]
} ON COLUMNS
,non empty {
[Affaires].[Affaire].children
// filter([Affaires].[Libelle Affaire].Children
// , [Affaires].[Assistante].&[13])
* [Affaires].[Libelle Affaire].Children
* [Entites Clientes].[Code Entite].Children
* [Entites Clientes].[EntiteCliente].Children
// * [Grands Comptes].[Entite Cliente Mere].Children
* [Geographie - Societe].[Code Departement Geo].Children
* [Affaires].[Libelle Departement].Children
}
having [Measures].[Proposition - Total Ca Produit HT]
+ [Measures].[Proposition - Total Ca Frais HT]
+ [Measures].[Proposition - Ca Produit HT Planifie]
+ [Measures].[Proposition - Ca Frais HT Planifie]
+ [Measures].[Proposition - Ca Produit HT Preste]
+ [Measures].[Proposition - Ca Frais HT Preste]
+ [Measures].[Proposition - Ca Produit HT Facture]
+ [Measures].[Proposition - Ca Frais HT Facture] > 0
ON ROWS
//FROM (SELECT([Affaires].[Chef De Projet].&[16]) ON COLUMNS
FROM (SELECT ([Affaires].[Assistante].&[13]) ON COLUMNS
FROM (SELECT ([Affaires].[Libelle Departement].[All]) ON COLUMNS
FROM (SELECT ([Affaires].[Etat Proposition].[All]) ON COLUMNS
FROM (SELECT ([Affaires].[Categorie Projet].[All]) ON COLUMNS
FROM (SELECT ([Affaires].[Application].&[2]) ON COLUMNS
FROM [MonCube])))))//) |
Partager