Rif,
I tried your code and seem to be able to get to the linked server but I now
get an error or incorrect syntax near cube.
**********************************
Error Diagnostic Information
OLEDB Error Code = 170
Line 3: Incorrect syntax near 'Cube'.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (2:1) to (2:48).
*************************************
Here is the mdx statement I want to execute:
SELECT ({[Measures].[MeasuresLevel].Members}) ON COLUMNS FROM [The Cube]
'* Here is the code generating the error
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<cfquery datasource="The Cube" Name="My Cube">
set quoted_identifier on
SELECT o."[Measures].[Unit Sales]" as C, o."[Promotion Media].[Media
Type].[MEMBER_CAPTION]" AS R
FROM OPENQUERY(My Cube,
'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>
<html>
<head>
<title>Untitled</title>
</head>
<body>
<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>
</body>
</html>
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists