You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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";

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!