Direct internet connectivity to Analysis Services cubes is an Enterprise
Edition only feature.


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Kiran Math" <kiranmath (AT) hotmail (DOT) com> wrote

Then your best option is to write a web-based application, or purchase a
client-side tool which supports a thin-client option. Many of the high-end,
very functional tools support mid-tier servers -- and only need a browser on
the client. The down side is that they can also be expensive.

Another option which might work for you would be to use the new Reporting
Services component of SQL Server. Because you can query Analysis Services
from a RS report, you can use it as an inexpensive "thin-client" solution
(generate HTML formated reports against Analysis Services). That's the good
part. The bad part is that:
1) it only works with pre-defined MDX -- you must enter raw MDX (like raw
SQL) into RS. There is a simple visual editor (like what you get with MS
Access) for SQL; there is nothing for MDX -- you have to enter it in
by-hand. There is a visual editor coming for MDX as part of Yukon, but that
doesn't help you today with SQL Server 2000. You might be able to use a tool
like Proclarity which exposes the MDX statements that it uses for your
report author. That would work if they don't know MDX natively.
2) you can get drill-down (since RS supports it), but you don't get pivot
like many OLAP client-side tools.
3) the reports are not nearly as interactive as with MS Excel, OWC, or other
OLAP tools. You can't have users add dynamically new measures, etc. Reports
are much more static.

Hope that helps.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Kiran Math" <kiranmath (AT) hotmail (DOT) com> wrote

Hi,

I would suggest you to use the Panorama NovaView for display of MS
Analysis Services over the Internet with your standard SQL Server
2000. It is fast and with a lot of features. If you like to you can
add even MS Reporting Services to your internet solution. Panorama
NovaView will support Reporting Services with a very easy interface
for standard reporting and just click for adhoc reporting.

On our website you see some live Panorama internet website URLs.

Marco

www.gmsbv.nl - your Consultancy and Training partner for MS Analysis
Services and Reporting Services


"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote