Web Cube

Question

Web Cube

Mithrandir

SSCrazy

Points: 2628
More actions
August 3, 2004 at 12:06 pm

#108675

Hi, I've been reading a Cube tutorial and this is what I want to do:
http://www.informit.com/articles/article.asp?p=29756
html cube works great, but only work if I run it from a local drive (eg. c:\htmlCube.htm), but if I put it over an IIS server it simply does'nt look (eg. http://myserver/htmlCube.htm).
What really peaced me off is that even running directly but from a network unit file isn't displayed (eg. z:\htmlCube.htm)
Is there a method to be able to run this cube from my IIS server?
Thanks

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

jimkistner SSC Veteran Points: 243 More actions · Answer 1

You need to make a change on the Connection tab of the Data Link Properties.

Instead of putting localhost in the Data Source, leave the Data Source blank and put your OLAP server name in the location. For example if your OLAP server is on a machine named myOlapServer, and your local network has a DNS record for this server name, put myOlapServer in the Location box.

If you want Internet instead of Intranet access, then you need to put a name which external dns servers can find.

If your OLAP server is on the same machine as IIS (as mine is for testing), life is simple. For example, if your site name is mysite.com, put this in the location.

I am still using SQL Server 7. The above works for me and I think it should work for Analysis Services 2000. However I think I remember seeing something on the Microsoft website that said that you can also use HTTP to connect to Analysis Services 2000.

Hope this helps,

Jim

Mithrandir SSCrazy Points: 2628 More actions · Answer 2

Thanks Jim.

Yes, I've changed that, I can run exactly same HTM file from my desktop or from server's desktop and all works fine, that means I have no problem with datasources.

The problem is when I access that HTM from IIS service. I still been searching and found something related to Web-Analysis only available for Enterprise Edition (I got Standard). But I don't fully understand what that term means.

I still with the problem :-\ If you (or someone else) can help me I'll be very thankful

jimkistner SSC Veteran Points: 243 More actions · Answer 3

Well I'm confused. I thought that the "Web Analysis" you were referring to was the ability to use HTTP to tunnel through a firewall. Based on what I read on MS web site, this is only available in the Enterprise Edition. I thought the basic capability at getting to the data the old way was still there. In fact, I would have thought that you would have gotten a connection error in the Data properties window if you couldn't.

As I mentioned, I am using SQL Server 7. I designed a web page using Front Page 2002. I inserted the Pivot Table. I went to data connections, followed the steps above. Everything works fine.

What error message are you getting?

Mithrandir SSCrazy Points: 2628 More actions · Answer 4

Centainly I don't have a clear image of what "Web Analysis" means, just thought that maybe this could causing me the problem.

I have SQL Server 2000 Standard, and made HTM file with Frontpage 2000. I get no error message (the worst part), only the page title and a big white rectangle where cube is supposed to be :'-(

jimkistner SSC Veteran Points: 243 More actions · Answer 5

I was able to duplicate your problem, I think. I did it by designing a page using Frontpage 2000 that I have installed on a Win98 machine. I then copied it to my IIS directory on my Win XP machine. Whe I tried to open it using HTTP on either machine, all I got was a white rectangle.

I then compared the code between the working and the non-working page. The FP 2000 (non-working) page uses an active X control for the Microsoft Office PivotTable 9.0, whereas the FP XP (working) page uses the control for PivotTable 10.0.

I have office Web Components (OWC) 10.0 installed on both machines.

I changed the HTML source for the FP 2000 page to utilize the PivotTable 10.0 control. It works on both machines, both thru IIS and opening it from the local drive.

To further test this theory, I designed a new page in FP 2000, but used the 10.0 Pivot control instead of the default 9.0. It works fine on both machines.

So it looks like the answer may be to utilize OWC 10.0, which you can download from the Microsoft web site if you don't already have it installed.

Good Luck.

Mithrandir SSCrazy Points: 2628 More actions · Answer 6

Thanks a lot Jim, I'm very thankful

One more thing:

By company politics we only have office 2000 (and Office 2003 seems not to be here prior to 2005).

Do you know if is there a way to install OWC 10 in Office 2000 (wihtout using Office XP/2003)? Using Office Update only get up to 9.0.0.6621 SP-3

jimkistner SSC Veteran Points: 243 More actions · Answer 7

Yes, OWC 10 is a free download that works with either Office 2000 or Office XP. Following is a link to the download page:

http://www.microsoft.com/downloads/details.aspx?FamilyID=982b0359-0a86-4fb2-a7ee-5f3a499515dd&DisplayLang=en

If that link doesn't work, go to the general Microsoft download page, http://www.microsoft.com/downloads select Office System for the Product/Technology and enter the words "web components" in the Keywords box. Select "Office XP Tool: Web Components" from the results page.

Note: By default, Office 2000 programs will not use the version 10.0 Web Components Active X controls. For example, in Frontpage 2000, you need to manually insert the version 10.0 PivotTable control using the Advanced option of the insert menu. If you just select the normal Pivot Table from the menu, you will get the version 9.0, not version 10.0.

You need to install OWC10 on the computer that is using Frontpage. Also, you will need to install OWC10 on *any* computer that will view the resulting HTML page generated page.

Let me know how it works for you.

Mithrandir SSCrazy Points: 2628 More actions · Answer 8

Wow man, thank you very much!

It costed me 4-5 days of frustrations. 🙁

But it's finally running.

jimkistner SSC Veteran Points: 243 More actions · Answer 9

Glad it's working for you.

I know the frustrated feeling myself. I spent a lot of time trying to determine how to get a local cube built in Excel from an Access database to work on the web. I wanted to demo it to a client without having to go to their site. Never did get that to work, so I had to develop it in SQL7 OLAP services.

Good luck in your pursuit of on-line OLAP.

Alamir SSCertifiable Points: 6085 More actions · Answer 10

by the way, here is some links that may help u to understand OWC more

http://download.microsoft.com/download/c/2/8/c28831e9-684e-4aab-9af3-f061bf68ad70/WebCmpnt.doc

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B319793

http://support.microsoft.com/default.aspx?scid=kb;EN-US;235542

if you want more resources, I can send u 2 extra file on your mail

I hope this help u

Alamir Mohamed
Alamir_mohamed@yahoo.com