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.
Deepak Puri - 27 Apr 2005 01:33 GMT
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/details.aspx?FamilyId=7564A3FD-4729-4
B09-9EE7-5E71140186EE&displaylang=en
XML for Analysis 1.1 SDK
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
Malcolm Toon - 09 May 2005 12:44 GMT
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
> 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
[quoted text clipped - 7 lines]
> Thanks,
> Kevin E.
thiago leizico - 08 Feb 2010 13:01 GMT
cubos ola
From http://social.msdn.microsoft.com/Forums/pt-BR/analysisservicespt/thread/c60dd07b
-1666-474e-9dbd-bbc3a562823
Posted via DevelopmentNow.com Group
http://www.developmentnow.com/g/