Groups | Blog | Home
all groups > sql server reporting services > march 2005 >

sql server reporting services : Creating reports based on Analysis Services cubes


Chris Treanor
3/23/2005 10:45:03 AM
How do you create reports based on data that is in the AS cubes? We have
cubes that we are able to hit from Excel via the Pivot Table Service and
Analysis Services. However, we are trying to determine the best way to do
this in .Net and Reporting Services.

Thanks for your assistance.

Robert Bruckner [MSFT]
3/23/2005 4:02:25 PM
I assume you are asking for Analysis Services 2000 and Reporting Services
2000. Did you check the following MSDN article - it should get you started:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp


-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Chris Treanor
3/24/2005 6:41:04 AM
Your assumptions are correct. Thanks for the article. However, If I was using
AS 2005 or RS SP2 would this be different? How? Is there a way to get
involved with the beta of these apps?

Thanks

[quoted text, click to view]
Robert Bruckner [MSFT]
3/24/2005 4:55:53 PM
RS 2000 SP2 would not change anything in this area.
RS 2005 includes a graphical query designer for MDX and DMX queries,
multi-value parameter support for MDX/DMX, etc.

If you are a MSDN subscriber, you can download the latest SQL Server 2005
CTP (February CTP) and see the differences in AS 2005 and RS 2005.


-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

AddThis Social Bookmark Button