Connecting to SQL Server OLAP Cube from MX7

Can anyone direct me to information on how to connect to an OLAP cube from ColdFusion MX7. It is generated from SQL Server 2000 Analysis Services. I need to convert a web site written in .Net to ColdFusion. In .Net they use ADOMD.Net data provider. Any information or links to info on making

RE: Connecting to SQL Server OLAP Cube from MX7

Can anyone direct me to information on how to connect to an OLAP cube from ColdFusion MX7. It is generated from SQL Server 2000 Analysis Services. I need to convert a web site written in .Net to ColdFusion. In .Net they use ADOMD.Net data provider. Any information or links to info

ColdFusion and OLAP Access

I'm stumped and need to consult the expert here: Can anyone tell me if it is possible to use ColdFusion with Hyperion Essbase 6.1 or Microsoft Analysis Services? Two OLAP database products. Any hints, tips, tricks, hacks, documentation, or URL's would be greatly appreciated. Thanks, Dave

OLAP

Has anyone out there connected to MSSQL2000 OLAP cubes using CF? If you have, any suggestions? I'm tearing out my already thinning hair just trying to figure out if it's possible. Ideally, I'd like to be able to analyze a cube the same way folks do it using Excel or Access... Ian Portent

Re: OLAP

Has anyone out there connected to MSSQL2000 OLAP cubes using CF? If you have, any suggestions? I'm tearing out my already thinning hair just trying to figure out if it's possible. Ideally, I'd like to be able to analyze a cube the same way folks do it using Excel or Access... I haven't

(OT) SQL Server 7 licensing, ASPEN beta, and OLAP services

I am creating a reporting environment. Or getting going on it anyway. I want SQL Server 2000 running OLAP services and will use Seagate Software BI product beta'ing as ASPEN. Question? Is there a single user licence for SQL Server 2000? Can I use MSDE to create OLAP cubes? Still reading

PLEASE HELP--Querying Olap Cube Through MDX and CF--PLEASE HELP

Hello, I am attempting to query an Olap Cube through using MDX through CF. I am using a com object and can see the cube but am unable to get any data from it. I used a custom tag to see what was being returned and all that is returned is a space. I was told by Ben Forta that I would need

RE: PLEASE HELP--Querying Olap Cube Through MDX and CF--PLEASE HELP

This is what I do when I want to query OLAP from CF. Make a LinkServer from MS SQL Server to MS OLAP Server. The setting are : Provider Name : Microsoft OLE DB Provider for OLAP Product Name: MSOLAP Datesource : OLAP SERVER NAME Provider string : Location

Please Help ---Querying olap cubes with mdx---Please Help

Rif, Thanks for your response. I set up my linked server but just have a few questions. How do I get to the linked server through coldfusion? How do I set up my datasource in Cf Administrator? Also, why did you use the o. "" as c in your expressions? Why did you use the o and c?

RE: PLEASE HELP--Querying Olap Cube Through MDX and CF--PLEASE HELP

PROTECTED]] Sent: 17 November 2000 19:40 To: Rif Kiamil Subject: RE: PLEASE HELP--Querying Olap Cube Through MDX and CF--PLEASE HELP Rif, Thanks for your response. I set up my linked server but just have a few questions. How do I get to the linked server through coldfusion? How do I set up my da

OLAP Cube connect through CF with mdx

Does anyone know how to query an olap cube using mdx within Cold Fusion? I can get to the cube but do not get any output. THanks, Eddie Archives: http://www.mail-archive.com/cf-talk

URGENT HELP NEEDED: using cf to connect to an olap cube

Has anyone ever used cf to connect to an olap cube using mdx? I found this sample on the allaire message boards and it connects to our cube but will not return any data. Any suggestions would be greatly appreciated. This queries the sample cube that comes with OLAP services. Eddie !DOCTYPE

querying olap cubes through cf with mdx

Hello, Has anyone successfully used mdx to query an olap cube? I am able to get to the cube through coldfusion but can't get any output. Any suggstions? Thanks, Eddie body cfset adOpenStatic = 3 cfset adLockReadOnly = 1 cfset adCmdText = 1 !--- Grab the component--- cfobject type=&quo

sorry to ask again, I just need help! Olap and mdx

Hello, Has anyone successfully used mdx to query an olap cube? I am able to get to the cube through coldfusion but can't get any output. Any suggstions? Thanks, Eddie body cfset adOpenStatic = 3 cfset adLockReadOnly = 1 cfset adCmdText = 1 !--- Grab the component--- cfobject type=&quo