Setup Query for cube data in RS2000

[pdebaerd]

Hello,

I want to query data from a cube in analysis services with parameters in reporting services. I'm not sure how to make my select statement. Can someone help me please

Pat

[rmiao]

You need mdx query, different from t-sql. Take look at 'SELECT Statement (MDX)' in books online.

[Island1]

While MDX is certainly neceessary, parameterization in Reporting Services will take a wee bit more than simply using MDX SELECT statements ... see the numerous articles in my RS Services series (which concerns itself with Analysis Services reporting almost exclusively) surroudning parameterization, among which here are only a recent handful:

Reporting Services: Customize Automatically Created Parameter Support Objects

Parameter Support Objects, Pt II: Support OLAP Parameter Defaults with Datasets

Support Parameterization from Analysis Services

Parameterization from Analysis Services – Cascading Picklists

Support Parameterization from Analysis Services – Parameter Defaults .

Look these over and see if you get the basic concepts ... and, if you hae further questions, feel free to post here for all the help you need!

Bill

[pdebaerd]

Hello,

Thanks for info, i tried to build my querie but without success Query is

Select
{[Omzstatwin_Time].[Maand].members} ON COLUMNS,
{[Omzstatwin_Customer].[Statistiek].members} ON ROWS
from [Omzstatwin]

Get an error message in Formula error cannot find dimension member : ([Omzstatwin_Time].[Maand])

Thanks for your advice to find a solution