We have a requirement to create cubes using Microsoft Analysis Services and access it using Pivot Table (or some other tool) over the internet. Has anyone done this or knows how to go about doing it? Any help will be greatly appreciated.

MJ,

People posted the Microsoft version of the OLAP thin client at (works
great on smaller cubes):

http://groups.msn.com/OLAPServicesDe...?action=get_me
ssage&mview=0&ID_Message=45&LastModified=467545262 7789731202

http://groups.msn.com/OLAPServicesDevelopersForum

For a thick client and that uses .NET (works with bigger cubes):

http://msdn.microsoft.com/msdnmag/is...P/default.aspx

Enjoy,

Phin

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thanks d d for your response. We have already tried the thick client solution provided on msdn. It works great over the internal LAN. But can not access the cube when accessing from outside through the internet. SQL Server, Analysis Services and IIS are all installed on the same Windows 2000 server which has an external IP address. Any pointers??????

Are you using SQL Server Exterprise Edition ???


over the internal LAN. But can not access the cube when
accessing from outside through the internet. SQL Server,
Analysis Services and IIS are all installed on the same
Windows 2000 server which has an external IP address. Any
pointers??????

We are using SQL Server Developer Edition. As per Microsoft, functionally it is same as Enterprise Edition with different license requirements.

I would look at the section called "Configuring the OLAP Source for HTTP
Access":

http://msdn.microsoft.com/msdnmag/is...P/default.aspx

I believe the datasource in your web.config file
needs to have your domain.

Hope this helps!


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!