Reporting on an Analysis Services data cube

Hello,

The problem I am having is I am trying to report on an Analysis Services data cube.

I connect fine but for some reason the "MDX query designer" does not appear as an option for creating the query for this data source. Is there a component of SQL 2000 or visual studio I am missing

Any help Would be great

Thank you

One good starting point might be this link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&DisplayLang=en

It is a rs 2000 sample that uses cubes. I hope this helps

|||Just to confirm - are you using RS 2005 with the Analysis Services Provider - otherwise you won't get the MDX Query Designer?|||

Thank you for your help. I unfortunately am only using RS2003.

SO i need to upgrade to RS 2005 and install Analysis Services Provider before ill get the designer ?

|||

You would need to upgrade RS 2005 - the Analysis Services Provider should get added as part of the upgrade:

http://msdn2.microsoft.com/en-us/library/ms170417(SQL.90).aspx

>>

What's New in SQL Server 2005 > Reporting Services Enhancements

Reporting Services Design-Time Enhancements

New Analysis Services Query Designer

Report Designer includes a new query designer for creating MDX queries. You can use the integrated query designer for Analysis Services to build queries by dragging and dropping server metadata onto a report layout and previewing the results.

>>