MS SQL Server OLAP - OLAP Cube output to web

Author

OLAP Cube output to web

0212353

2005-08-11, 8:24 pm

I recently created my first OLAP cube on our SQL Server at work. I
currently am able to view the cube through a pivot table in excel and I
have set up a website using the office web controls to view the cube.

Everything works great if you have Office 2003 on your computer, but
most of the computers at work run Office 97/2000. Excel 97 does not
have the functionality to connect to the OLAP cube. Most of the
computers with Office 2000 do not have the most up to date MDAC.
Getting our IT guys to install these updates is a pain (most users do
not have admin rights). The website is pretty much the same thing,
software is needed to view it.

I am looking for a way to access this OLAP cube from our website,
without the need for any software on the user's side of things. I am
open for anything, ActiveX, ASP, etc.

Is there a walkthough for this sort of thing somewhere?

Thank you.

olap@gmsbv.nl

2005-09-01, 8:24 pm

Hi,

I would recommend you to use for internet a 100% HTML solution based on
ReportPortal. You can order a free 60-days trial from www.gmsbv.nl.
Here We have also some live production websites usong MS AS 2000 +
ReportPortal and Panorama NovaView.

Regards, Marco

0212353 schreef:

> I recently created my first OLAP cube on our SQL Server at work. I
> currently am able to view the cube through a pivot table in excel and I
> have set up a website using the office web controls to view the cube.
>
> Everything works great if you have Office 2003 on your computer, but
> most of the computers at work run Office 97/2000. Excel 97 does not
> have the functionality to connect to the OLAP cube. Most of the
> computers with Office 2000 do not have the most up to date MDAC.
> Getting our IT guys to install these updates is a pain (most users do
> not have admin rights). The website is pretty much the same thing,
> software is needed to view it.
>
> I am looking for a way to access this OLAP cube from our website,
> without the need for any software on the user's side of things. I am
> open for anything, ActiveX, ASP, etc.
>
> Is there a walkthough for this sort of thing somewhere?
>
> Thank you.

olap@gmsbv.nl

2005-09-01, 8:24 pm

jporzak@gmail.com

2005-09-20, 9:23 am

Hi,

We use OpenI (www.OpenI.org) - the open source web OLAP frontend - to
deliver AS2K results over the web to our client base and have been
doing so for over six months. OpenI works fine with IE, Firefox & even
the Apple web browsers.

In interest of disclosure, Sandeep Giri, our VP of R&D, is the project
lead. Sandeep just released v1.1 yesterday. Since our client services
group depends on OpenI, we are devoting significant resources to OpenI.
Also, other organizations are making significant contributions to the
project. OpenI has broken into the top 100 on SourceForge. The project
definitely has traction.

Personally, I have been using OLAP for over 6 years & am familiar with
some of the best products: OlapHub, Cognos PowerPlay, etc. I find OpenI
easy and intuitive - as do our clients. While early in it's evolution,
it's ready for prime time. Check it out.

HTH
Jim Porzak
Director of Analytics
www.LoyaltyMatrix.com

Sponsored Links