dbTalk Databases Forums  

OLAP Cube output to web

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss OLAP Cube output to web in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
0212353
 
Posts: n/a

Default OLAP Cube output to web - 08-11-2005 , 08:06 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.


Reply With Quote
  #2  
Old   
olap@gmsbv.nl
 
Posts: n/a

Default Re: OLAP Cube output to web - 09-01-2005 , 04:00 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:

Quote:
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.


Reply With Quote
  #3  
Old   
olap@gmsbv.nl
 
Posts: n/a

Default Re: OLAP Cube output to web - 09-01-2005 , 04:01 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:

Quote:
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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.