Hi all,

I would like to know how to get OLAP to work in ColdFusion.

I've tried adding the datasource under SQL Server but am getting the
following error:
"Cannot open database requested in login 'FoodMart'. Login fails."

Anyone knows how to make it work?

Thank you

Regards,
Yee Tien

If you want to connect to Analysis services from a client you have to use
the ADO for Multidimensional Objects (ADOMD) driver instead of ADO. I think
it is part of MDAC 2.7 and above, which means that it should be installed on
your machine if you are up-to-date with the Windows Service Packs.

--
Jacco Schalkwijk
SQL Server MVP


"ennovations" <yeetien (AT) ennovations (DOT) com.sg> wrote

Hi Jacco,

Thanks for replying

I've managed to connect to the database using your method.

However, I got stuck again when trying to access the result.

I'm having "Invalid number of parameters" error when accessing
adocst.axes.item[0] (it's in ColdFusion syntax).

Do you know why the error is showing? I thought item only takes in an
int.

Regards,
Yee Tien


"Jacco Schalkwijk" <jacco.please.reply (AT) to (DOT) newsgroups.mvps.org.invalid> wrote

Can you post your complete statement?

--
Jacco Schalkwijk
SQL Server MVP


"ennovations" <yeetien (AT) ennovations (DOT) com.sg> wrote

Hi Jacco,

My code is below:

<CFOBJECT ACTION="CREATE" TYPE="COM" class="ADOMD.Cellset"
NAME="adocst">

<CFSET AdoCst.ActiveConnection = "Provider=MSOLAP;Data
Source=localhost;Initial Catalog=FoodMart;">

<CFSET AdoCst.source = "SELECT TopCount({[Product].[Product
Name].Members}, 1,
Measures.[Unit Sales]) ON COLUMNS FROM [Sales]">

<cfset AdoCst.open()>

<cfset iColDim = AdoCst.axes.item[0].dimensioncount>

The last statement is where I got the error.

Thanks

Regards,
Yee Tien



"Jacco Schalkwijk" <jacco.please.reply (AT) to (DOT) newsgroups.mvps.org.invalid> wrote

Try items(0) instead of items[0].

--
Jacco Schalkwijk
SQL Server MVP


"ennovations" <yeetien (AT) ennovations (DOT) com.sg> wrote

Hi Jacco,

Thanks for your reply again

I tried with () and got the following error:
Item cannot be found in the collection corresponding to the requested
name or ordinal. in 'ADOMD.Axes'.

I think ColdFusion index with []. I got the idea from the thread
below:
http://groups.google.com/groups?hl=e...macromedia.com

But the method still not working for me...

Regards,
Yee Tien


"Jacco Schalkwijk" <jacco.please.reply (AT) to (DOT) newsgroups.mvps.org.invalid> wrote