1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| SELECT NON EMPTY { [Measures].[Qté], [Measures].[Valeur DG] }
ON COLUMNS, NON EMPTY { ([Calendrier].[Date].[Date]
.ALLMEMBERS * [Type Ecriture Stock].[Type Ecriture Stock].[Type Ecriture Stock].ALLMEMBERS
* [Ecritures Stocks].[Numero].[Numero].ALLMEMBERS
* [Ecritures Stocks].[Code Motif].[Code Motif].ALLMEMBERS * [Articles].[Article].[Article].ALLMEMBERS *
[Articles].[- Id Article].[- Id Article].
ALLMEMBERS * [Articles].[AXE1].[AXE1].
ALLMEMBERS * [Articles].[AXE4].[AXE4].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( Filter( [Articles].[- Id Article].[- Id Article].ALLMEMBERS, Instr( [Articles].
[- Id Article].currentmember.Properties( 'Member_Caption' ), 'A031861' ) > 0 ) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ArticlesAXE, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TypeEcritureStockTypeEcritureStock, CONSTRAINED) )
ON COLUMNS FROM ( SELECT ( STRTOSET(@CalendrierMois, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Calendrier].[Année].&[2009] } )
ON COLUMNS FROM [PPM Stocks]))))) WHERE ( [Calendrier].[Année].&[2009], IIF( STRTOSET(@CalendrierMois, CONSTRAINED).Count = 1,
STRTOSET(@CalendrierMois, CONSTRAINED),
[Calendrier].[Mois].currentmember ) )
CELL PROPERTIES VALUE, BACK_COLOR,
FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS" |
Partager