We have several rdl files and we have 2 problems with them! Error 1- When we do a Preview in one of them, there's an error message: "Query execution failed for data set '<one cube dimension>' Parser: The syntax for 'the' is incorrect" Error 2 - In the preview of other rdl file, we get: " An error occured during local report processing. Error during processing of '<on cube dimension>' Report Parameter. We are working in VS2005 and SQL 2005. We are working in a development environment(with localhost) (If, anyone need more information regarding these errors, please ask) Anyone can help us , finding where could be the origin of these errors ? Thanks in advance Nuno

can you share your mdx query from the dataset related to error 1?

Sure.... SELECT { [Measures].[KPI CumplimenT], [Measures].[KPI Metric], [Measures].[KPI Cumpliment], [Measures].[KPI Value T], [Measures].[KPI Total T], [Measures].[KPI Metric T], [Measures].[KPI Total], [Measures].[KPI Value] } ON COLUMNS, { ([dim_Update_Dates].[Month Year].[Month Year].ALLMEMBERS * [dim_KPI_Relationships].[KPI - Customer].[Customer].ALLMEMBERS * [dim_KPI_Relationships].[KPI Code].[KPI Code].ALLMEMBERS * [dim_KPI_Relationships].[Customer Code].[Customer Code].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [dim_KPI_Relationships].[KPI Code].&[P-AV-01], [dim_KPI_Relationships].[KPI Code].&[P-AV-02], [dim_KPI_Relationships].[KPI Code].&[P-CM-1], [dim_KPI_Relationships].[KPI Code].&[P-SM-21], [dim_KPI_Relationships].[KPI Code].&[P-AV-04] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@dimKPIRelationshipsCustomer, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( -{ [dim_KPI_Relationships].[KPI Module].&[Technical Support] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@dimUsersUser, CONSTRAINED) ) ON COLUMNS FROM [cb_KPIs])))) WHERE ( IIF( STRTOSET(@dimUsersUser, CONSTRAINED).Count = 1, STRTOSET(@dimUsersUser, CONSTRAINED), [dim_Users].[User].currentmember ), IIF( STRTOSET(@dimKPIRelationshipsCustomer, CONSTRAINED).Count = 1, STRTOSET(@dimKPIRelationshipsCustomer, CONSTRAINED), [dim_KPI_Relationships].[Customer].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS Nuno

do any of your variable values (the values you pass for @dimKPIRelationshipsCustomer for example have odd characteres like apostrophes or quotes?

No, BI.... All values are "normal" text! The only "stange" value that i have i an empty value, but i think that is still valid, right ? Thanks NunoNuno