I am having a hard time with this. I have a report that has two main datasets: one which pulls based on DischargeDate parameter and another which pulls based on ReceivedMonth parameter. This is an OLAP database. I want to use a single parameter which is used by both dataset so the user just has to choose 'April 2010' for example and it is used by both. I cannot get this to work. I am new to MDX. Is there an easy way to do this?

Anyone?

Hi B K Howard, Based on your Description, you would like to use a parameter to supply different datasets, it could be achieved in SSRS . Please follow steps as below to add a parameter in MDX query in SSRS. 1. In the Report Data pane, right-click on a dataset created from a SQL Server Analysis Services data source type, and then clicks Query. The MDX query designer opens in Design mode. 2. On the toolbar, click Design to toggle to Query mode. 3. On the MDX query designer toolbar, click Query Parameters. The Query Parameters dialog box opens. 4. In the Parameter column, click <Enter Parameter>, and then type the name of a parameter. 5. In the Dimension column, choose a value from the drop-down list, for example, select “Date”. 6. In the Hierarchy column, choose a value from the drop-down list, for example, select “Date.Date” 7. In the Default column, type in the value which you used as default value, for example, type in “2010-4-1” In the Report Data pane, expand the Parameters node to display the report parameter that was automatically created for the filter. And you can repeat the steps above to add the parameter in another dataset. For more details about it, please see the following article, How to: Define Parameters in the MDX Query Designer for Analysis Services (Report Builder 3.0 and SSRS): http://technet.microsoft.com/en-us/library/ms156303.aspx If you have any question, please feel free to ask. Thanks, Eileen

I have done what you say, but it apparently does not put the parameter into the mdx query..... so even though I have defined the parameter using the instructions above, it is not being used correctly..... ideas?

Hi B K Howard, After you compete the steps I have mentioned above, the parameter is not display in MDX query. You can find the parameter using following steps. 1. Right-click the dataset, select Dataset Properties. 2. Change to Parameters tab, and then you can see the parameters you add previously. If you would like to add the parameters in MDX query, please refer to the following article: Using Variables and Parameters (MDX): http://msdn.microsoft.com/en-us/library/ms145518(v=SQL.100).aspx If you have any question, please feel free to ask. Thanks, Eileen

I am confused... When just doing the original steps and the parameter is not displayed in MDX query... are you saying that the parameter is still being used by MDX query even though it does not show?