The good news is, first of all, it's possible to build reports based on MDX Add data source based upon 'Microsoft OLE DB Provider for Olap Services 8.0' and specify MDX query selecting from some cube. For example, given FoodMart 2000 sample distributed with MSAS, specify the following query:
select
{[Measures].members} on Columns,
{[Store].members} on rows
from Sales.


[показать]


The bad news is that mentioned Olap provider does have native support for (both named and unnamed) parameters. As a compensation, Reporting Services enables the queries to be generated dynamically at runtime.
To create a parameter for a report based on Analysis Services data you should create a new dataset that will be used to populate the parametrs values and write something like
WHERE (" + Parametes!MyParam.Value + ")"
instead of
WHERE @parameter.
Could one ask why the @parameter is only supported by the ole (sql)-db-provider?