Up-to-date list of VBA Functions in MDX

MDX 1 Minute

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.

Published by Chris Webb

My name is Chris Webb, and I work on the Fabric CAT team at Microsoft. I blog about Power BI, Power Query, SQL Server Analysis Services, Azure Analysis Services and Excel.

Published

6 thoughts on “Up-to-date list of VBA Functions in MDX”

  1. gbrueckl – Austria – Gerhard has been implementing traditional BI and data warehouse solutions based on the Microsoft Data Platform for over 10 years and has been sharing his knowledge with the community ever since. With the rise of “Big Data” over the last years he also shifted his interests towards new technologies, mainly related to the Hadoop eco system to fight the masses of data he frequently encounters at his customers. Having this strong background with the Microsoft Data Platform, he always tries to combine this “old” and the “new” world which still have a lot of things in common!
    gbrueckl says:

    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

    Reply
    1. Chris Webb – My name is Chris Webb, and I work on the Fabric CAT team at Microsoft. I blog about Power BI, Power Query, SQL Server Analysis Services, Azure Analysis Services and Excel.
      Chris Webb says:

      Good question, I don’t know!

      Reply
  2. Pingback: Un peu de MDX de bon matin… | La BI ça vous gagne!
  4. Pingback: Calculating Ages In MDX | Chris Webb's BI Blog
  5. Pingback: Calculating Ages In MDX - SQL Server - SQL Server - Toad World

Leave a Reply to gbruecklCancel reply