locked
Increase performance in mdx query RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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