SSAS Cube in the Cloud

Sammy Deprez
Data Fish
Published in
1 min readJun 21, 2012

These days we hear so much about putting all our services in the cloud
For my main job i’m working on an reporting application, that is web-based but our analysis reports are with Excel with an SSAS Cube

So we were thinking to offer our product as a service to clients instead as an application.

Reporting is already web-based so that’s not a problem. But SSAS and Excel…
Well that’s why I’v been looking for a way to connect to SSAS thru HTTP
And I found a nice blogpost

http://bloggingabout.net/blogs/mglaser/archive/2008/08/15/configuring-http-access-to-sql-server-2008-analysis-services-on-microsoft-windows-server-2008.aspx

So know we can connect to our cubes with excel over the http protocol :)

--

--