Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Up-to-date list of VBA Functions in MDX

with 6 comments

Some of you may be aware that a few VBA functions have been implemented as native MDX functions to improve performance. I blogged about this a few years ago, but I’ve now received an up-to-date list of all the VBA functions that that this has happened for as of SSAS 2012 SP1 from those nice people on the SSAS dev team:

CDate
CDbl
CInt
CLng
CStr
Int
Month
Now
IsArray
IsError
Abs
Round
InStr
LCase
Left
Len
Mid
Right

As far as I can see, it’s Month() and LCase() that are the new ones on this list, and which were added in 2012 SP1. Still no Log10() function though, alas.

Thanks to Akshai and Marius for their help with this.

Written by Chris Webb

December 12, 2012 at 7:07 am

Posted in MDX

Tagged with

6 Responses

Subscribe to comments with RSS.

  1. Hey Chris,
    so those are the functions that are optimized to operate in bulk-mode, right?

    how about UCase()?
    if LCase() works, why should UCase()?

    greets,
    gerhard

    gbrueckl

    December 17, 2012 at 9:43 pm

  2. […] de caractères (hur hur), ça va être un bonheur… Trêve de sarcasme, on peut utiliser quelques fonctions VBA en MDX qui vont ici nous sauver la mise (à adapter en fonction des formats de vos […]

  3. Thank you for this list!

    Jay

    December 23, 2013 at 8:29 pm

  4. […] to use functions like DateDiff() – one of the VBA functions that is available in MDX (but is not native MDX). The following article shows how DateDiff() and other VBA functions can be used to calculate ages […]

  5. […] to use functions like DateDiff() – one of the VBA functions that is available in MDX (but is not native MDX). The following article shows how DateDiff() and other VBA functions can be used to calculate ages […]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,083 other followers

%d bloggers like this: