Groups | Blog | Home
all groups > sql server reporting services > september 2004 >

sql server reporting services : Reporting from Cubes??


Steve
9/22/2004 11:03:45 PM
Hi,
I have a question. Can we use Reporting Services to
report from OLAP Cubes. If yes, can we write MDX also to
report from Cubes using Reporting Services.

Thanks

Robert Bruckner [MSFT]
9/23/2004 9:27:53 AM
For RS 2000 please read this MSDN article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
You may also want to download these samples:
http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&DisplayLang=en

RS 2005 Beta 2 contains a graphical MDX query designer which will generate
the MDX for you.

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


[quoted text, click to view]

Dennis Redfield
9/23/2004 9:34:04 AM
short answer: yes and yes. Look at MSDN for a slide show from teched'04 on
MDX expressions and Reporting Services. If you use proclarity you might
also want to contact Proclarity for a reference for their soon to be
product - an add in to Reporting Services for Proclarity views.

hope this helps.
dlr
[quoted text, click to view]

Dennis Redfield
9/24/2004 10:09:01 AM
I have always like this paragraph from the msdn article:

[quoted text, click to view]
information.However, only one is ideal when used as >a source for a matrix
in a report.
[quoted text, click to view]
be able to discern which of these expressions will >work as the source of a
matrix, and which will not.



but thanks for playing....







[quoted text, click to view]

AddThis Social Bookmark Button