Re: XIRR from MDX?

#1

Partially solved... With some help from Microsoft I realized what was
a basic misunderstanding.

You can not use "USE LIBRARY" in the same script as your MDX query.
You have to execute it by itself first then execute the query that
references the external library. I was trying to do both in the same
batch.

We are still working on creating a VB.NET COM Interop object that can
be registered with Analysis Services.

Greg

gregcarder (AT) hotmail (DOT) com (Greg) wrote in message news:<d61bada1.0307081227.3471783d (AT) posting (DOT) google.com>...

Quote:

Hello all,

I'm trying to use the XIRR function in Excel from MDX. I have
installed Analysis Toolpack for Excel that contains XIRR so that is
not a problem.

My first hope was that XIRR would simply be available from MDX because
the Excel functions are included automatically without using USE
LIBRARY.

This does not appear to be the case. I've read on other posts some
sample code to run XIRR from VBA. Using something like:

Set objExcel = New Excel.application
objExcel.RegisterXLL "C:\Program Files\Microsoft
Office\Office\LIBRARY\ANALYSIS\ANALYS32.XLL"

Our development environment is .NET 2003 using VB.NET. I tried
creating a custom DLL using the COM Interop project template so that I
could make the XIRR call from within code I control. I have not been
able to use this DLL from within the MDX Sample application. Whenever
I include "USE LIBRARY" I get an error about "expecting end of
statement but found extra text, near: WITH". This happens for my DLL
or any other DLL that I try to include.

1) Is it possible to use USE LIBRARY from within the MDX sample
application?
USE LIBRARY "c:\abc.dll"

WITH

MEMBER ...

Select....

2) Are there any good samples of using XIRR from Excel?

3) Has anyone successfully used .NET 2003 to create a DLL accessible
from MDX?

Any thought/help would be appreciated!

Thanks,

Greg

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: XIRR from MDX?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: XIRR from MDX? - 07-13-2003 , 11:19 PM