How To Use Parameters In The MDX?

Hi all,

I'm working on a project that builds a report in RS 2005 agains the data cube created in AS 2005.

I created a report in RS 2005 against database table, and the parameters were easy to be added in the T-SQl query.

There are about 15 parameters needs to add in the query, and I can use "IN, =, Betweent.. and ," in the "where" clause, e.g.,

select *
FROM Mytable1
WHERE EmployeeID IN (@EmployeeID)
and EmployeeName] IN (@EmployeeName)
...
and Salary between @SalaryFrom and @SalaryTo

... and Date between @DateStart and @DateEnd



most of the restriction fields are column fileds in the report.



Right now, I need to switch the datasource to the data cube, and then I have to use MDX to do the query. But I really cannot get enough information about MDX in the MSDN library --> SQL Server Language Reference -->MDX Reference to write a MDX query, especially with parameters.

Could somebody tell me how to do it?

please give me a complete example for the following T-SQL query:

select t1.EmployeeName, t2.Salary, t3.Date, t4.SaleAmount


FROM Mytable1 t1, mytable2 t2, mytable3 t3, mytable4 t4


WHERE t1.EmployeeName IN (@EmployeeName)
...
and t2.Salary between @SalaryFrom and @SalaryTo

... and t3.Date between @DateStart and @DateEnd

and t4.SaleAmount betweent @SaleAmountFrom and @SaleAmountTo

in the cube, those data are stored in DimEmployee (field EmployeeName), DimSalary(filed Salary), DimDate, FactSales, and the SaleAmount will be the messure field.

Or if sombody can provide me the link to MDX tutorial other than what I can get from the "MDX reference" I mented above, I'll be very appreciated !!

Thanks!!

Jone