This is what I do when I want to Query MSOLAP from ColdFusion.
<cfquery datasourc="SQLSERVERDATABASE" Name"OLAPTEST">
set quoted_identifier on
SELECT o."[Measures].[Unit Sales]" as C, o."[Promotion Media].[Media
Type].[MEMBER_CAPTION]" AS R
FROM OPENQUERY(OLAP_TEST, '
select
{Measures.[Unit Sales]} on columns,
order(except([Promotion Media].[Media Type].members,{[Promotion
Media].[Media Type].[No Media]}),[Measures].[Unit Sales],DESC) on rows
from Sales
')
as o
set quoted_identifier off
</CFQUERY>
<table>
<tr>
<td>Unit Sales</td>
<td>Media Type</td>
</tr>
<cfoutput query="OLAPTEST">
<tr>
<td>#OLAPTEST.C#</td>
<td>#OLAPTEST.R#</td>
</tr>
</cfoutput>
</table>
Hope this helps
>From Rif
PS Where it has OLAP_TEST, that is a link server from my SQL to my OLAP
database
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 22 November 2000 14:57
To: CF-Talk
Subject: Custom output tag
Hello,
I was able to query an olap cube through cf but didn't get a result. I was
told me code should work, I just need to play with the output of the query
to put it in a form that cf will understand. I used the querydump tag and
it said returned a space....any suggestions on how I can see the query
results?
Thanks,
Eddie
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
