Reporting from Cubes?

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
Steveshort 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
"Steve" <anonymous@.discussions.microsoft.com> wrote in message
news:43cf01c4a133$15c93b50$a501280a@.phx.gbl...
> 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
> Steve|||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.
"Steve" <anonymous@.discussions.microsoft.com> wrote in message
news:43cf01c4a133$15c93b50$a501280a@.phx.gbl...
> 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
> Steve|||I have always like this paragraph from the msdn article:
>For example, the two MDX queries below return the exact same
information.However, only one is ideal when used as >a source for a matrix
in a report.
>MDX Expression
>SELECT
> CROSSJOIN ({[Measures].[Unit Sales]},{[Time].[Month].members}) on
columns,
> NON EMPTY ([Store].[Store City].members) on rows
>FROM SALES>MDX Expression
>SELECT
> CROSSJOIN ({[Measures].[Unit Sales]},{[Time].[Month].members}) on
columns,
> NON EMPTY ([Store].[Store City].members) on rows
>FROM SALES>By the time you've finished reading this whitepaper, you should
be able to discern which of these expressions will >work as the source of a
matrix, and which will not.
but thanks for playing...
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23DTCIpYoEHA.3556@.TK2MSFTNGP10.phx.gbl...
> 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.
>
> "Steve" <anonymous@.discussions.microsoft.com> wrote in message
> news:43cf01c4a133$15c93b50$a501280a@.phx.gbl...
> > 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
> >
> > Steve
>