Reporting on an Analysis Services data cube

Reporting on an Analysis Services data cube

• cdmdc

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

• Alok Mani

  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.

  >>

  
  
  

• SCChoose

  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

  
  

• Ki Dae KIM

  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

  
  
• Reporting on an Analysis Services data cube