locked
Increase performance in mdx query RRS feed

  • Question

  • Hi all ,

    I am newbie in BI and MDX query,

    Can anyone recommend how can i optimize MDX QUERY (tips) to improve performance ?

    Regards ,Evgeniy


    Thursday, July 24, 2014 2:17 PM

Answers

All replies

  • Hi Evgeniy,

    According to your description, you are looking for the tips to improve the performance of the MDX query, right?

    In this case, please refer to the links below which describe the most common best practices that the Microsoft SQL Server development team recommends with respect to optimizing Analysis Services query performance.
    SSAS - Best Practices and Performance Optimization
    Analysis Services Query Performance Top 10 Best Practices

    If you have any questions, please feel free to ask.

    Regards,


    Charlie Liao
    TechNet Community Support

    • Marked as answer by Charlie Liao Sunday, August 3, 2014 12:19 PM
    Friday, July 25, 2014 6:48 AM
  • In terms of a piece of code, this is one that I generally use.

    IIF(ISEMPTY([your measure[)= TRUE,NULL,[Your MDX Query[)

    Friday, July 25, 2014 10:41 AM