Choosing Between Member Set Functions and Performance

Queries and calculations that reference a member that has been tagged as Dynamic Calc may be significantly slower than queries and calculations involving the same members, if the member has formulas involving any of these functions:

• @CURRMBR

• @PARENT

• @SPARENTVAL

• @ANCEST

• @SANCESTVAL

If you are experiencing slow performance, consider either removing the dynamic calculation tag or removing these functions from the attached formula.