Being new to OLAP, this will probably be an easy question. I have installed
analysis services and have built a cube and the data looks great in the cube
data browser. Now, how do I get this data to end users. I know I can use
Excel Pivot Reports, but we use Delphi 2005 and am wondering if anyone has
used Delphi to access cubes and report the data. If not, can anyone
recommend a good program and third party plug-in to access cube data and get
it to the users. Also, I would like the data to look like it is in the cube
data browser.

Thanks,
Kevin E.

adding OLAP group

--

-Jamie MacLennan
SQL Server Data Mining
This posting is provided "AS IS" with no warranties, and confers no rights.
"KevinE" <eckart_612 (AT) hotmail (DOT) com> wrote

Can you be more specific, I'm not following what you are saying. Adding an
OLAP component in Delphi? I have tested a couple of components out, but none
seem to work very well.

Thanks,
Kevin

"Jamie MacLennan (MS)" <jamiemac (AT) online (DOT) microsoft.com> wrote

Why not try accessing cube data in Delphi 2005 via a Web Service, using
the XML for Analysis (XMLA) standard? XMLA is the standard interface to
Analysis Services 2005, but you can use the SDK to provide XMLA access
to Analysis Services 2000 as well:

http://www.microsoft.com/downloads/d...564A3FD-4729-4
B09-9EE7-5E71140186EE&displaylang=en

This SDK is a middle tier that allows a client complying with the XML
for Analysis (XMLA) version 1.1 specification to communicate with an
Analysis Services 2000 server.

Overview

The Microsoft® XML for Analysis 1.1 SDK contains the Microsoft® XML for
Analysis provider and sample client applications. The Microsoft® XML for
Analysis provider supports client access to analytical data sources
(OLAP and data mining) residing on the Web. This provider implements the
XML for Analysis Specification, version 1.1, which provides for open
data access to analytical data sources residing over the Web, without
the need to deploy a client component that exposes COM interfaces.
Microsoft Analysis Services 2000 server can be accessed with the
provided download, from a web client, without any COM components on the
client. For more information, read the XML for Analysis specification,
version 1.1, available at http://www.xmla.org.

Support for the XML for Analysis 1.1 SDK is available via the following
newsgroup: microsoft.public.data.xmlanalysis.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

You could import the Pivot Table OLE control. I tried this and it works
pretty good. You can also run MDX queries against the database using the
ADO driver... this is more limited as it's not really an active cube viewer,
but more of a results viewer (standard grid).

We've been building a large scale implementation of MSAS using Delphi 7 as
the backend processor, but not for GUI purposes. There are a lot of tools
out there, maybe you can check those out?

Also, this link is helful:
http://www.olap.ru/desc/microsoft/odelphi.asp

-m

"KevinE" <eckart_612 (AT) hotmail (DOT) com> wrote

cubos olap

From http://social.msdn.microsoft.com/For...d-bbc3a5628237

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/