Need to find a solution or 3rd party solution which we can use in our MY application
to show the results of Analytical reports in web page through AJAX or any other option,
that should allow us drill down or other standard features to resort or regroup the report
at run time. We don't want to use excel activeX, as in that case we would need to expose our
SSAS database directly on internet.

Re: Need help in Sql server analysis solution

Vidas Matelis

One list of 3rd party tools can be found here: http://www.ssas-info.com/ssas_products.html

Also- if your clients do have excel and just a security is an issue, you should look into option on connecting to analysis services using http. More info about this here: http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx

Vidas Matelis