anyone?Microsoft Techie

Are you passing full parameter value for date? e.g. instead of passing '20110120', instead pass '[DATE].[DATE].&[20110120]' . I am not sure but you may try using ServerReport.GetParameters() to verify the expected parameter value you should pass.

Thank Arun, But I dont think I understood your statement correctly. What is the significance of passing '[DATE].[DATE].&[20110120]'?? Microsoft Techie

Hi {P}, That is because your datasource here is SSAS, which use MDX query, not Select query. In MDX we operate in the multidimensional hierarchized space. I.e. we have many dimensions, and every dimension has hierarchical structure (MDX allows to same dimension to have more than one hierarchical structure, but we’ll talk about it later). Obviously we need set of functions to navigate in this hierarchical multidimensional space. By defining the query’s axes, you specify lower-dimensionality subspace of your query (optionally sliced by WHERE condition). You also want to have functions to navigate in this subspace, knowing where you are, moving to the right direction etc. If you have dimension member, you may apply several methods on it: Parent, NextMember, PrevMember, FirstSibling, LastSibling, FirstChild, LastChild etc. The outcome will be another dimension member with obvious relationship to original one. For example the writing [WA].Parent is equivalent to write [USA]. Of course nobody will use [WA].Parent instead of [USA], and we’ll see much more useful application of Parent in a moment. Often, you want to know the coordinates of the cell by some specific dimensions inside the query’s subspace. This can be achieved by function <dimension name>.CurrentMember <level name>.CurrentMember A MDX query example here: SELECT Measures.MEMBERS ON COLUMNS, {[Store].[Store State].[CA].CHILDREN, [Store].[Store State].[WA].CHILDREN} ON ROWS FROM [Sales] WHERE (Measures.[Sales Average], [Time].[Year].[1997]) More information about The Basisi MDX Query, please refer: http://msdn.microsoft.com/en-us/library/aa216770.aspx Thanks, Lola Please remember to mark the replies as answers if they help.

Sorry... I still can't figure how would I pass the required value to parameter in RDLMicrosoft Techie

I have a RDL file who's data and parameter values are coming from an OLAP cube. The parameter is a simple Date parameter. I am trying to call this report from an aspx page using ReportViewer control. When I pass the parameter with following code I get the 'parameter is missing value' error. Here's my code: ReportParameter p = new ReportParameter("RunDateRunDate", strDate); ReportViewer1.ServerReport.SetParameters(new ReportParameter[] { p }); ReportViewer1.ServerReport.Refresh(); Microsoft Techie

Hi {P}, There are two similar thread about pass date time parameter to MDX query for you to refer: http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/fd12a865-bc90-4a65-af42-ce38a8cfa29b/ http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/aea7e435-f635-4abc-aea3-e0e644d97541/ For better understanding, here is a good article about Using Reporting Services with SSAS data: http://denglishbi.wordpress.com/2008/03/01/using-reporting-services-ssrs-with-ssas-data/ Thanks, Lola Please remember to mark the replies as answers if they help.