Post reply

Excel functions in MDX

  • January 14, 2014 at 5:31 am

    #148131

    Hi All.

    Is there a way to reference Excel functions from MDX ?

    I'm trying to access the LOG function. I can reference the VBA LOG function like so VBA![LOG]([Measures].[xxxxxxx but this VBA LOG function is different to the Excel worksheet LOG function. The VBA one uses a natural log whereas Excel has a parameter for the Base and defaults to 10.

    Regards,

    James

  • January 15, 2014 at 3:40 am

    #1680171

    You can use log10(Measures.[i]your measure[/i])

    More info here.

    🙂

    I'm on LinkedIn

  • January 15, 2014 at 3:53 am

    #1680177

    Presumably, I will need Excel installed on my server for this to work ?

  • January 15, 2014 at 4:13 am

    #1680182

    I believe so, if this thread is anything to go by.

    I'm on LinkedIn

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply