dbTalk Databases Forums  

Reporting from Cubes??

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Reporting from Cubes?? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Steve
 
Posts: n/a

Default Reporting from Cubes?? - 09-23-2004 , 01:05 AM






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



Reply With Quote
  #2  
Old   
Michael Vardinghus
 
Posts: n/a

Default Re: Reporting from Cubes?? - 09-23-2004 , 04:11 AM






Yep..

http://msdn.microsoft.com/library/de...lapasandrs.asp

michael

"Steve" <anonymous (AT) discussions (DOT) microsoft.com> skrev i en meddelelse
news:1f5c01c4a133$4883d5a0$a601280a (AT) phx (DOT) gbl...
Quote:
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





Reply With Quote
  #3  
Old   
Mick Horne
 
Posts: n/a

Default Re: Reporting from Cubes?? - 09-23-2004 , 01:15 PM



Yes you can....

....but support isn't great. Data is returned "flat" and you have to code
dynamic MDX if you want to include parameters in your RS reports (as these
aren't supported natively).

Mick

"Steve" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
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





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.