1 2 3 4 5 6 7 8 9 10 11 12
|
="SELECT
NON EMPTY { [Measures].[Debit Euro], [Measures].[Credit Euro] } ON COLUMNS,
NON EMPTY { ([Segments].[Compte].[Compte].ALLMEMBERS * [Temps Periode].[Date].[Date].ALLMEMBERS * [Ecritures].[No Ecriture].[No Ecriture].ALLMEMBERS * [Ecritures].[Description].[Description].ALLMEMBERS * [Batchs FMS].[Batchs FMS].[Batchs FMS].ALLMEMBERS * [Ecritures].[Catégorie Ecriture].[Catégorie Ecriture].ALLMEMBERS * [Devises].[Devise].[Devise].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION,
MEMBER_UNIQUE_NAME ON ROWS
FROM
( SELECT ( STRTOSET(""{" + Join(Parameters!ChoixTypes.Value,",") + "}"", CONSTRAINED) ) ON COLUMNS
FROM
( SELECT { [Temps Periode].[Date].[Date].Item(DateDiff(""d"", [Temps Periode].[Date].[Date].Item(0).MemberValue, CDate("""+Format(Parameters!FromTempsProductionDate.Value,"MM/dd/yyyy")+"""))): [Temps Periode].[Date].[Date].Item(DateDiff(""d"", [Temps Periode].[Date].[Date].Item(0).MemberValue, CDate("""+Format(Parameters!ToTempsProductionDate.Value,"MM/dd/yyyy") + """))) } ON COLUMNS
FROM
( SELECT {" + Parameters!ChoixBureau.Value + "} ON COLUMNS FROM [FMS])))
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS" |
Partager