hello,
i work with Reporting Services 2005 and i need de display data from my cube according to a value chosen by the user.
when i use the wizard to add the parameter date to my query,the typ is string.it works in condition to choose de parameter from the list of dates my cube.
Code:
SELECT NON EMPTY { [Measures].[Flux Op] } ON COLUMNS, NON EMPTY { ([Periode Dim 1].[Periode Dim].[Periode Dim].ALLMEMBERS * [Ecriture 1].[Domiciliation].[Domiciliation].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@PeriodeDimPeriodeDim, CONSTRAINED) ) ON COLUMNS FROM [cube_base_test]) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
when i change the type into datetime in order the date frm the calender, i have error message(with strtoset).
i have tried something like: where("&Parameters!PeriodeDimPeriodeDim.Value&") it doesn't work.
i need your help
thanks a lot
problem with the parameter date in a mdx query
