dbTalk Databases Forums  

Reporting Service

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


Discuss Reporting Service in the microsoft.public.sqlserver.olap forum.



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

Default Reporting Service - 03-17-2005 , 10:14 PM






I am trying to use Reporting Service with Analysis Service but I'm not too
sure as to how to go about doing that.

Can someone point some articles or tutorials to me ?

Thanks in advance



Reply With Quote
  #2  
Old   
Dario Concilio
 
Posts: n/a

Default RE: Reporting Service - 03-18-2005 , 04:29 AM






First problem is configure correctly data set source.
You must use MDX language for obtain data information from olap cube.

You must use some tip&trics for provide data using matrix or table object.
For example when you get data from "MDX query" you have a list of records
with
additional lines for all totale dimensions and sub-dimension.

This additional line can be omitted if you want usa table object or you can
use it by matrix object for provide a dimensional total.

It's most important use expression code on text object (of your matrix code
for example) for personalize Caption label, filter etc.



"Nestor" wrote:

Quote:
I am trying to use Reporting Service with Analysis Service but I'm not too
sure as to how to go about doing that.

Can someone point some articles or tutorials to me ?

Thanks in advance




Reply With Quote
  #3  
Old   
Joerg
 
Posts: n/a

Default RE: Reporting Service - 03-18-2005 , 08:13 AM



check this:

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

"Dario Concilio" wrote:

Quote:
First problem is configure correctly data set source.
You must use MDX language for obtain data information from olap cube.

You must use some tip&trics for provide data using matrix or table object.
For example when you get data from "MDX query" you have a list of records
with
additional lines for all totale dimensions and sub-dimension.

This additional line can be omitted if you want usa table object or you can
use it by matrix object for provide a dimensional total.

It's most important use expression code on text object (of your matrix code
for example) for personalize Caption label, filter etc.



"Nestor" wrote:

I am trying to use Reporting Service with Analysis Service but I'm not too
sure as to how to go about doing that.

Can someone point some articles or tutorials to me ?

Thanks in advance




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.