MDX and VBA functions

#1

Apologies, this is a cross-post from oledb.olap.

To my understanding, using VBA in my calculated members should work "out of
the box"

Simply put: I cant seem to get VBA funnctions to work in my calculated
members.

I try:

strToMember("[Time].[All Time].[" + VBA!year(now()) + "]")

And it gives me a "token not valid" error.

Im running AS SP3.

Anyone know what im doing wrong?

#2

Peter Koller wrote:

Quote:

Apologies, this is a cross-post from oledb.olap.

To my understanding, using VBA in my calculated members should work
"out of the box"

Simply put: I cant seem to get VBA funnctions to work in my calculated
members.

I try:

strToMember("[Time].[All Time].[" + VBA!year(now()) + "]")

And it gives me a "token not valid" error.

Im running AS SP3.

Anyone know what im doing wrong?

Leave out the VBA! part, just type year(now()), that should work

#3

Sorry, im still getting the "token not valid error".
When i register my own libraries it works, just not with the supposedly pre
regsitered vba functions..

"Hans van Kruijssen" <hans.vanKruijssen (AT) agilisys (DOT) com> skrev i melding
news:edAadmDWEHA.2844 (AT) TK2MSFTNGP12 (DOT) phx.gbl...

Quote:

Peter Koller wrote:

Apologies, this is a cross-post from oledb.olap.

To my understanding, using VBA in my calculated members should work
"out of the box"

Simply put: I cant seem to get VBA funnctions to work in my calculated
members.

I try:

strToMember("[Time].[All Time].[" + VBA!year(now()) + "]")

And it gives me a "token not valid" error.

Im running AS SP3.

Anyone know what im doing wrong?

Leave out the VBA! part, just type year(now()), that should work

#4

Peter Koller wrote:

Quote:

Sorry, im still getting the "token not valid error".
When i register my own libraries it works, just not with the
supposedly pre regsitered vba functions..

"Hans van Kruijssen" <hans.vanKruijssen (AT) agilisys (DOT) com> skrev i melding
news:edAadmDWEHA.2844 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Peter Koller wrote:

Apologies, this is a cross-post from oledb.olap.

To my understanding, using VBA in my calculated members should
work "out of the box"

Simply put: I cant seem to get VBA funnctions to work in my
calculated members.

I try:

strToMember("[Time].[All Time].[" + VBA!year(now()) + "]")

And it gives me a "token not valid" error.

Im running AS SP3.

Anyone know what im doing wrong?

Leave out the VBA! part, just type year(now()), that should work

That is weird, since here it is working.
I have no idea what it could be then.

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

MDX and VBA functions

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

MDX and VBA functions - 06-22-2004 , 03:52 AM

Re: MDX and VBA functions - 06-22-2004 , 04:16 AM

Re: MDX and VBA functions - 06-22-2004 , 05:05 AM

Re: MDX and VBA functions - 06-22-2004 , 05:31 AM