OLAP activeX

[Bob Baeyens]

Hi,

We are looking to deploy OLAP services on the Web. I was looking into
PowerPlay and the likes, when somebody pointed me out, that SQL Server OLAP
services actually comes with an ActiveX control, that you can simply drop on
a webpage to access OLAP cubes. He claims this is the very same control that
the OLAP client software uses.

Anybody got any experience with this control ? Does it exist ? What about
licensing ? Since PowerPlay costs an arm and a leg, any information is VERY
welcome. (if possible also by email bob.b...@realsoftware.be)

Thx,

Bob

[Taylor Boswell]

This should give you the object you desire in a web page assuming the
control is registered on your machine.
<object classid="clsid:6D6671B5-4119-11D2-93F3-00104B2B96D7"
height="547" id="CB" style="LEFT: 0px; TOP: 0px" width="927">
<param NAME="_ExtentX" VALUE="16589">
<param NAME="_ExtentY" VALUE="14473"></object>
Follow it up with some code to set the connect string and you should be
ready to go.
function ImageClick()
cb.ConnectWStr "TMS1AS11", "ALOE2", "ALOE2"
end function
You can also use the control from VB by adding the "OLAP Manager Cube
Browswer" control to a project. The only bad thing is you can't print
the data from this control or dump it to a file. Otherwise it is a very
simple solution!

[Taylor Boswell]

[Bob Baeyens]

> This should give you the object you desire in a web page assuming the
> control is registered on your machine.

Does that mean, the client has got to have the olap services installed,
so that the ocx is local ? Or will it be downloaded automatically ?

> <object classid="clsid:6D6671B5-4119-11D2-93F3-00104B2B96D7"
> height="547" id="CB" style="LEFT: 0px; TOP: 0px" width="927">
> <param NAME="_ExtentX" VALUE="16589">
> <param NAME="_ExtentY" VALUE="14473"></object>
> Follow it up with some code to set the connect string and you should be
> ready to go.
> function ImageClick()
> cb.ConnectWStr "TMS1AS11", "ALOE2", "ALOE2"
> end function

Where TMS1AS11 is the server name I suppose ? and ALOE2 database and
datacube ?

> You can also use the control from VB by adding the "OLAP Manager Cube
> Browswer" control to a project. The only bad thing is you can't print
> the data from this control or dump it to a file. Otherwise it is a very
> simple solution!

I dont understand Microsoft doesnt document this control ANYWHERE.
I mean, I found out about it, by looking at the source code of the
FoodMarker example in the MMC. I look everywhere for a control that
does exactly this !

Anyway, thx a lot already

[Amir Netz]

The control shipped with the OLAP Manager is an internal part of the Manager
and was not intended to be used by other applications. This is why it is not
documented anywhere, not supported and not licensed to be used in your own
app.

Office 2000 comes with a set of web controls that are much more functional
then the "OLAP Manager Cube Browser" and are fully compatible with OLAP
Services. I recommend you to try these out. Office 2000 is about to be
released so it should be available soon.

Bob Baeyens <bob.b...@realsoftware.be> wrote in message
news:7dfdc8$e52$1...@news3.Belgium.EU.net...

[Scott Wheeler]

Amir,
I have the Office2000 preview edition, I got it in January. I've
installed and used Excel2000 to access my MS OLAP cubes.
How do I use the other web controls in Office 2000 that you mentioned?

Scott Wheeler

Amir Netz wrote in message ...

[Amir Netz]

The Office Web Controls are part of this beta. You should be able to find
info about these in the documentation.

Scott Wheeler <swhe...@ensemble.net> wrote in message
news:OxeGaMte#GA....@cppssbbsa02.microsoft.com...

[Olivier Matrat]

Scott,

An easy way of getting started with the Office Web Components is to create a
PivotTable in Excel2000, then save it as an HTML page checking the "add
interactivity" option.

This will give you a first glimpse into the PivotList control
fonctionalities...

Olivier.

Scott Wheeler wrote in message ...

[Amir Netz]

I discovered that the controls are not getting installed by a default
upgrade installation. You need to ask for them in the custom install under
"Office Tools". You'll find there "Office Web Controls"

Scott Wheeler <swhe...@ensemble.net> wrote in message
news:OxeGaMte#GA....@cppssbbsa02.microsoft.com...

[Bob Baeyens]

Olivier,

I do not have Office2000 beta (yet), but Im intrested in finding out about
these OLAP Cube controls. Do you know a webpage where I can get some details
about them ? I searched MS, but they are kinda vague...

Also, does this control support printing (descent) reports ?

thx,

Bob
Olivier Matrat wrote in message ...

[Olivier Matrat]

Bob

Try this link on MIND to get the big picture :
http://www.microsoft.com/mind/1298/inthisissue1298.htm

You may find additional information at : http://www.microsoft.com/office

If you wish I can also send you a few white papers offline.

As for printing, the PivotList control (in the beta2 version I am testing)
doesn't handle it directly, you have to use the browser's printing
capabilities.
However what you can do is export the PivotList to an Excel PivotTable (this
function is handled natively by the PivotList ActiveX control) at the
client, and thus handle printing directly from within Excel.

Olivier.

Bob Baeyens wrote in message <7e21p3$bkk$1...@news3.Belgium.EU.net>...