I have been working with SQL Server 2000 Analysis Services (called OLAP Services in SQL Server 7) to create OLAP cubes from both VFP and Oracle data. I can create the cubes but need some advice on how to post the results of the cubes to the internet. My end-users are 1,000 miles away so it is imperative that I give them the ability to review the reports on-line over the web.

I was leaning toward using the Excel 2000 Pivottable list that is part of the Office web components. However, I am having some difficulties getting it all to work properly.

Has anyone had success creating some type of interactive reporting on the web using OLAP cubes? Any tips, links or advice would be appreciated. I am not required to only use Excel, but that does offer a nice interface that my users are already familar with.

Tom Bellmer
Overland Park, KS