Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Analysis (OLAP) / February 2010

Tip: Looking for answers? Try searching our database.

Delphi and OLAP

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
KevinE - 25 Apr 2005 22:56 GMT
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/
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.