SmartView performance issue with multiple member formulas
Summary:
We have created close to 500 member formulas for some statistical calculations. Currently, we are experiencing performance issues with SmartView retrieval and are seeking ways to optimize performance. Most of the calculations are straightforward. Below are some examples:
Account2:
IF(@ISMBR(@IANCESTORS("FCCS_No Intercompany" -> "C1None" -> "C2None" -> "C3None" -> "MvmtAvgRate")))
Account1 -> "FCCS_Intercompany Top" -> "Total Custom1" -> "Total Custom2" -> "Total Custom3" -> "MvmtTot" +
Account1 -> "Dec" -> @MEMBER(@PREVSIBLING(@CURRMBR("Years"))) -> "FCCS_Intercompany Top" -> "Total Custom1" -> "Total Custom2" -> "Total Custom3" -> "MvmtTot" -
Account1 -> @MEMBER(@PREVSIBLING(@CURRMBR("Years"))) -> "FCCS_Intercompany Top" -> "Total Custom1" -> "Total Custom2" -> "Total Custom3" -> "MvmtTot";