all groups > sql server data warehouse > october 2007 >
You're in the

sql server data warehouse

group:

Analysis Services 2005 and Web Services


Analysis Services 2005 and Web Services Doomed ReportsGuy
10/5/2007 8:17:19 AM
sql server data warehouse: Can Analysis Services read Web Services, then relate that data to other
cubes or data sources?

Thanks



Re: Analysis Services 2005 and Web Services Joe
10/5/2007 10:13:16 AM
Hey Doomed...I think I liked the sounds of what you were looking for - what
were you hoping to do?

[quoted text, click to view]
Re: Analysis Services 2005 and Web Services Jeje
10/5/2007 12:47:02 PM
no
SSAS can access only structured data sources (ie databases, flat files...)
you have to extract the data from the webservice and store this into a local
database.

[quoted text, click to view]
Re: Analysis Services 2005 and Web Services Doomed ReportsGuy
10/5/2007 3:05:15 PM

Joe, I'm just seeing If I could grab certain data from a Web service
method (like on a drill thru). That would be cool. Thanks everyone for
the replies.

Doomed!


Re: Analysis Services 2005 and Web Services Jeje
10/5/2007 6:50:21 PM
the drillthrough return detail from the database, so again, you can't return
data from an external source.

you can create some actions to open a webpage where you consume the
webservice. (with some parameters coming from the cube)
you can also consume a webservice in Reporting Services as a datasource, and
you can use open the report as an action from your cube.
so instead of a drillthrough command, the user will execute an action which
open the report or the webpage

in fact, the drillthrough is just another action type in SSAS.

do you use your own client application?
or do you use an existing olap client tool?

[quoted text, click to view]
AddThis Social Bookmark Button