Re: Test For Connectivity

From: Joe Genshlea (joegensh_at_yahoo.com)
Date: 03/23/04 

Date: Mon, 22 Mar 2004 19:59:27 -0800

Would theSoapClient.cls from the Sample.vdp do the trick? Should I make an
ActiveX.dll from it?

Is there anywhere in the documentation that discusses how to integrate XMLA
with non-.NET/Studio technology?

Joe

"Chris Harrington" <charrington@activeinterface.com> wrote in message
news:Oe5Jo6HEEHA.2628@TK2MSFTNGP11.phx.gbl...
> XMLA is a SOAP service so you need to use a SOAP client library to call
it.
>
> "Joe Genshlea" <joegensh@yahoo.com> wrote in message
> news:uM$B3eFEEHA.4080@TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > I am writing a coldfusion application and would just like to test
> something
> > very simple.
> >
> > I have test the following MDX statement in the sample app and now I'd
like
> > to execute it through a ColdFusion App. When I run this MDX through the
> > ColdFusion App I get
> >
> > "Connection Failure"
> >
> >
> >
> >
>
ColdFusion -----------------------------------------------------------------
> > -----------------
> >
> > <HTML>
> >
> >
> > <CFFILE ACTION = READ
> > VARIABLE = MyXML
> > file = "c:\inetpub\wwwroot\intranet\modules\HelloWorld.xml">
> >
> >
> > <CFOUTPUT> #MyXML# <BR> </CFOUTPUT>
> >
> > <CFHTTP METHOD ="POST" URL = "http://localhost/xmla/msxisapi.dll">
> >
> > <CFHTTPPARAM NAME = "body" VALUE ="#ToString(myXML)#" type
="XML"
> > >
> > </CFHTTP>
> >
> > <CFOUTPUT>
> > #CFHTTP.filecontent#
> > </CFOUTPUT>
> >
> >
> >
> > </HTML>
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
Helloworld.xml--------------------------------------------------------------
> > -------------------
> >
> > <query>
> > SELECT NON Empty crossjoin ({[Property Type].members},
> > {[Measures].members}) on columns,
> > NON EMPTY {[Territory].[All Territory].[Central
Region].children}
> on
> > rows
> > From Sales
> > where [Business Close].[Month].&[99]
> > </query>
> >
> >
> > Data Sources-----------------------------------------------
> >
> > - <DataSources UnnamedSessionsTimeout="300" NamedSessionsTimeout="3600"
> > MaxRequestSize="128" AllowInsecureTransport="1">
> > - <DataSource>
> > <DataSourceName>Local Analysis Server</DataSourceName>
> > <DataSourceDescription>Microsoft Analysis Server 2000 on
> > CHEF</DataSourceDescription>
> > <URL>http://localhost/xmla/msxisapi.dll>
> > <DataSourceInfo>Provider=MSOLAP.2;Data Source=chef; </DataSourceInfo>
> > <ProviderName>Microsoft XML for Analysis</ProviderName>
> > - <ProviderType>
> > <TDP />
> > <MDP />
> > <DMP />
> > </ProviderType>
> > <AuthenticationMode>Unauthenticated</AuthenticationMode>
> > </DataSource>
> >
> >
>
>