Hi all,

I have a lot of MDX queries that worked OK on AS 2000. I recently started
migrating to AS2005 but queries that have date() function doesn't work.

AS installed these assemblies:
System, VBAMDXInternal, VBAMDX and ExcelMDX.

By the way, I am using Analysis Services 2005 with SP1.

Thanks everybody,

Andrés

Hi Andrés,

You're right, the Date() function doesn't work for me in AS 2005
Adventure Works - but Now() still seems to work. So could you use
something like:

Format(Now(), "d")
select {[Measures].[Today]} on 0
from [Adventure Works]
---------------------------------
Today
4/25/2006

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi Deepak

Yes. It works. But we have a lot of DTS, Scripts and Reports that depend on
date() function. Which library has the date() function?
Its possible to register the old DLL?

Regards,

Andrés



"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote

Andrés,

I checked the list of VBA functions exported by the VBAMDX assembly
(this is outlined on page 363 of the Applied MSAS 2005 book by Teo
Lachev), and Date() is still there. So the problem is probably due to a
collision with the reserved usage of Date elsewhere - this also happened
with Log().

Enclosing "Date" in square brackets resolves this issue:

CStr(VBA![Date]())
select {[Measures].[Today]} on 0
from [Adventure Works]
---------------------------------
Today
4/25/2006

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Yes.

However, if we have to change all to Vba![date()] I think we should change
everything to Now().

Thanks a lot!

Andrés




"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote