Performance
Discussion List
"},"updateUserID":null,"lastUserID":19500,"lastUser":{"userID":19500,"name":"josephwood","url":"https:\/\/community.anaplan.com\/profile\/josephwood","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/19500.jpeg","dateLastActive":"2023-06-05T08:23:08+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/CMA.png\")
"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":51,"score":null,"hot":3365324260,"url":"https:\/\/community.anaplan.com\/discussion\/155502\/options-to-improve-performance-when-loading-flat-list-used-in-reporting","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155502\/options-to-improve-performance-when-loading-flat-list-used-in-reporting","format":"Rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-04T07:54:57+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":136,"urlcode":"Performance","name":"Performance"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"},{"tagID":1143,"urlcode":"reporting","name":"reporting"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":71180,"type":"discussion","name":"1.05-05 Format the Display Name property as a list if possible","excerpt":"Format the Display Name property for Numbered lists as List Formatted, not text. This is more efficient, saves a line item, minimizes text fields and simplifies mappings. However, it not recommended to create a separate list purely for this purpose; use an existing list if possible","categoryID":85,"dateInserted":"2020-05-20T12:08:50+00:00","dateUpdated":null,"dateLastComment":"2023-04-22T12:54:10+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/us.v-cdn.net\/6037036\/rank\/1.png\")
"},"updateUserID":null,"lastUserID":240,"lastUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":191,"score":1,"hot":3272147880,"url":"https:\/\/community.anaplan.com\/discussion\/71180\/1-05-05-format-the-display-name-property-as-a-list-if-possible","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/71180\/1-05-05-format-the-display-name-property-as-a-list-if-possible","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":80762,"type":"discussion","name":"2.02-10 Using PREVIOUS() vs CUMULATE()","excerpt":"For long timescales, using PREVIOUS is faster than CUMULATE due to the number of \"reads\" required for the calculation. So, the expression should be: 'Calc line item' = 'data line item' + PREVIOUS('Calc line item') rather than CUMULATE('data line item') Exception: 2.02-10a Short Timescales: Where the number of periods is…","categoryID":85,"dateInserted":"2020-08-18T16:17:54+00:00","dateUpdated":null,"dateLastComment":"2023-04-21T07:22:37+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":102168,"lastUser":{"userID":102168,"name":"VRK96","url":"https:\/\/community.anaplan.com\/profile\/VRK96","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/UE02YVU2Q593\/n9VAUXA7D3LAU.jpg","dateLastActive":"2023-06-03T19:20:07+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/general+contributor.png\")
"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":211,"score":1,"hot":3279830731,"url":"https:\/\/community.anaplan.com\/discussion\/80762\/2-02-10-using-previous-vs-cumulate","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/80762\/2-02-10-using-previous-vs-cumulate","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":71183,"type":"discussion","name":"1.05-08 Use Composite lists rather than ragged","excerpt":"Composite lists are more flexible and calculate more efficiently so try and \"balance\" the hierarchies whenever possible Exception: * 1.05-08a Chart of Accounts, or financial reporting hierarchies: Chart of Accounts, financial reporting hierarchies are valid uses of non-composite lists","categoryID":85,"dateInserted":"2020-05-20T12:10:01+00:00","dateUpdated":null,"dateLastComment":"2023-03-11T17:40:21+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":53001,"lastUser":{"userID":53001,"name":"LethargicAnalyst","url":"https:\/\/community.anaplan.com\/profile\/LethargicAnalyst","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/B7LHCABJPIV9\/n7UL9BZ487MRC.jpg","dateLastActive":"2023-06-15T14:27:32+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":252,"score":null,"hot":3268536622,"url":"https:\/\/community.anaplan.com\/discussion\/71183\/1-05-08-use-composite-lists-rather-than-ragged","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/71183\/1-05-08-use-composite-lists-rather-than-ragged","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":102615,"type":"discussion","name":"1.07-03 Turn summaries off on Collect() line items","excerpt":"By default, you should turn summaries off on line items using the Collect() function. By having summaries turned on, the system is aggregating data that is not usually needed. Related to Rule: 2.01-10 Calculation Modules 2.03-01 Turn Summary options off by default","categoryID":85,"dateInserted":"2021-03-22T10:12:31+00:00","dateUpdated":null,"dateLastComment":"2021-03-22T10:12:31+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":71,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/102615\/1-07-03-turn-summaries-off-on-collect-line-items","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/102615\/1-07-03-turn-summaries-off-on-collect-line-items","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":102586,"type":"discussion","name":"2.02-21 Don't use TIMESUM with Time","excerpt":"TIMESUM formulas should not be used in a line item that applies to Time, the formula will be duplicated for each time period. If the TIMESUM does use time periods then consider using MOVINGSUM instead. https:\/\/www.youtube.com\/watch?v=PvimWuX5jVw","categoryID":85,"dateInserted":"2021-03-22T07:31:29+00:00","dateUpdated":null,"dateLastComment":"2021-03-22T07:31:29+00:00","insertUserID":220,"insertUser":{"userID":220,"name":"MarkWarren","url":"https:\/\/community.anaplan.com\/profile\/MarkWarren","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/220.png","dateLastActive":"2023-06-08T16:11:47+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":121,"score":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/102586\/2-02-21-dont-use-timesum-with-time","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/102586\/2-02-21-dont-use-timesum-with-time","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/img.youtube.com\/vi\/PvimWuX5jVw\/0.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Untitled"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":93779,"type":"discussion","name":"Model Optimization Checklist","excerpt":"As your Anaplan platform grows and continues to expand beyond your initial use case, it remains just as important as it did on day one to make sure your models are built to perform and according to best practice. Check out the model optimization checklist to begin evaluating your models today!","categoryID":2,"dateInserted":"2020-12-18T06:15:32+00:00","dateUpdated":null,"dateLastComment":"2020-12-18T06:15:32+00:00","insertUserID":31571,"insertUser":{"userID":31571,"name":"CatherineH","url":"https:\/\/community.anaplan.com\/profile\/CatherineH","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/31571.jpeg","dateLastActive":"2023-06-15T13:01:43+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":1,"score":1,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/93779\/model-optimization-checklist","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/93779\/model-optimization-checklist","format":"html","groupID":51,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":2,"name":"Groups","url":"https:\/\/community.anaplan.com\/categories\/social-groups","allowedDiscussionTypes":["discussion","question","poll"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":90848,"type":"discussion","name":"5.04-11 Use zip files for faster imports","excerpt":"Anaplan will accept a zip file format as an import source. For large files, this will greatly improve the import speed","categoryID":85,"dateInserted":"2020-11-13T04:58:41+00:00","dateUpdated":null,"dateLastComment":"2020-11-13T04:58:41+00:00","insertUserID":157,"insertUser":{"userID":157,"name":"DavidSmith","url":"https:\/\/community.anaplan.com\/profile\/DavidSmith","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/157.jpeg","dateLastActive":"2023-05-10T18:49:38+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/us.v-cdn.net\/6037036\/rank\/100.png\")
"},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":92,"score":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/90848\/5-04-11-use-zip-files-for-faster-imports","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/90848\/5-04-11-use-zip-files-for-faster-imports","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":90844,"type":"discussion","name":"2.01-20 Use Appropriate Dimensions for modules","excerpt":"When creating a module, consider the scope of the calculation and only include the dimensions that are needed. If the formula doesn't return the value required, or errors, don't keep adding dimensions until it does; it is better to review the calculation itself. Check other modules; you may already have a calculation…","categoryID":85,"dateInserted":"2020-11-13T04:46:25+00:00","dateUpdated":null,"dateLastComment":"2020-11-13T04:46:25+00:00","insertUserID":157,"insertUser":{"userID":157,"name":"DavidSmith","url":"https:\/\/community.anaplan.com\/profile\/DavidSmith","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/157.jpeg","dateLastActive":"2023-05-10T18:49:38+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":21,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/90844\/2-01-20-use-appropriate-dimensions-for-modules","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/90844\/2-01-20-use-appropriate-dimensions-for-modules","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":90092,"type":"discussion","name":"2.01-19 Put Time and Versions list first in the dimension order","excerpt":"If you are using lists instead of native timescale or native versions, ensure these lists are placed as the first two lists in the dimension order. This mirrors the native time and version settings which will improve performance when mapping between native time\/versions and standard lists Best Practice Article: Dimension…","categoryID":85,"dateInserted":"2020-11-06T10:24:17+00:00","dateUpdated":null,"dateLastComment":"2020-11-06T10:24:17+00:00","insertUserID":157,"insertUser":{"userID":157,"name":"DavidSmith","url":"https:\/\/community.anaplan.com\/profile\/DavidSmith","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/157.jpeg","dateLastActive":"2023-05-10T18:49:38+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":11,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/90092\/2-01-19-put-time-and-versions-list-first-in-the-dimension-order","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/90092\/2-01-19-put-time-and-versions-list-first-in-the-dimension-order","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":90091,"type":"discussion","name":"2.01-18 Avoid copying large modules","excerpt":"Copying large modules, especially those with filters and many views, can take some time and block the model whilst doing so. For large modules, it is likely to be quicker to re-create the module Related to rule: 2.04-03: Keep the default view clean ","categoryID":85,"dateInserted":"2020-11-06T10:20:44+00:00","dateUpdated":null,"dateLastComment":"2020-11-06T10:20:44+00:00","insertUserID":157,"insertUser":{"userID":157,"name":"DavidSmith","url":"https:\/\/community.anaplan.com\/profile\/DavidSmith","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/157.jpeg","dateLastActive":"2023-05-10T18:49:38+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":1,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/90091\/2-01-18-avoid-copying-large-modules","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/90091\/2-01-18-avoid-copying-large-modules","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":90090,"type":"discussion","name":"1.02-05 Try and avoid a high number of native Versions","excerpt":"Versions have in built functionality that is not available for normal lists. However, a large number of Versions (e.g. 10+), can have performance implications due to the block structure and the lack of multi-threading available. Review the need for high number of Versions, and if the native functionality is not critical or…","categoryID":85,"dateInserted":"2020-11-06T09:55:47+00:00","dateUpdated":null,"dateLastComment":"2020-11-06T09:55:47+00:00","insertUserID":157,"insertUser":{"userID":157,"name":"DavidSmith","url":"https:\/\/community.anaplan.com\/profile\/DavidSmith","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/157.jpeg","dateLastActive":"2023-05-10T18:49:38+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":22,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/90090\/1-02-05-try-and-avoid-a-high-number-of-native-versions","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/90090\/1-02-05-try-and-avoid-a-high-number-of-native-versions","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"},{"tagID":197,"urlcode":"Versions","name":"Versions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":89877,"type":"discussion","name":"4.01-03 Create Output modules when using Custom Views","excerpt":"When staging line items are not needed to be viewed by the page builder, create an output module to be used for generating the Custom View Related to Rule: 2.01-04 Use the D.I.S.C.O. Methodology for Module Design ","categoryID":85,"dateInserted":"2020-11-04T12:21:11+00:00","dateUpdated":null,"dateLastComment":"2020-11-04T12:21:11+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":11,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/89877\/4-01-03-create-output-modules-when-using-custom-views","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/89877\/4-01-03-create-output-modules-when-using-custom-views","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":70316,"type":"discussion","name":"1.01-08 Daily Timescales on large timescales","excerpt":"Review the need for daily granularity for long timescales, specifically if the daily timescale spans five years or more. Use time ranges to restrict the daily calendars if possible and also use PREVIOUS rather than CUMULATE to optimise calculation efficiency. Related to Rule: 2.02-10 Using PREVIOUS vs. CUMULATE Best…","categoryID":85,"dateInserted":"2020-11-02T16:33:35+00:00","dateUpdated":null,"dateLastComment":"2020-11-02T16:33:35+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":31,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/70316\/1-01-08-daily-timescales-on-large-timescales","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/70316\/1-01-08-daily-timescales-on-large-timescales","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":70315,"type":"discussion","name":"1.01-07 Time Ranges","excerpt":"Use Time Ranges to optimize the modules where the default model calendar is not appropriate. Consider the dimensionality for the data and set up the Time Range accordingly. Best Practices article: Time Range Application","categoryID":85,"dateInserted":"2020-11-02T16:32:57+00:00","dateUpdated":null,"dateLastComment":"2020-11-02T16:32:57+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":11,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/70315\/1-01-07-time-ranges","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/70315\/1-01-07-time-ranges","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":71176,"type":"discussion","name":"1.01-05 Exclude timescale subtotals by default","excerpt":"Turn the \"include\" settings off by default and only include these if absolutely necessary. These additional settings (Quarter totals, Year to date, Year to go etc.) will be included in all modules with the model calendar as the time dimension. Thus they will perform calculations on these subtotals. Consider if you really…","categoryID":85,"dateInserted":"2020-11-02T11:27:21+00:00","dateUpdated":null,"dateLastComment":"2020-11-02T11:27:21+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":21,"score":3,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/71176\/1-01-05-exclude-timescale-subtotals-by-default","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/71176\/1-01-05-exclude-timescale-subtotals-by-default","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":71191,"type":"discussion","name":"1.06-03 Avoid single item subsets","excerpt":"If possible, try and avoid single item subsets, if there is a top level in the list, a single item subset will always have two members. Consider using a Boolean flag in a SYS module or a LOOKUP line item against the desired item (to avoid using SELECT)","categoryID":85,"dateInserted":"2020-05-20T12:16:06+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T03:43:17+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":103,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/71191\/1-06-03-avoid-single-item-subsets","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/71191\/1-06-03-avoid-single-item-subsets","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":71186,"type":"discussion","name":"1.05-11 Do not embed Numeric values or Dates within the Code of a list","excerpt":"Dates and values are \"data\" and should not be part of a code. Adding these elements to the code will in most cases, vastly increase the size of the list and consequently increase the mode size and reduce performance Best Practices article: Data Hubs Purpose and Peak Performance","categoryID":85,"dateInserted":"2020-05-20T12:10:45+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T03:40:43+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":41,"score":3,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/71186\/1-05-11-do-not-embed-numeric-values-or-dates-within-the-code-of-a-list","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/71186\/1-05-11-do-not-embed-numeric-values-or-dates-within-the-code-of-a-list","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":71182,"type":"discussion","name":"1.05-07 Avoid Top Level for large flat lists","excerpt":"The calculation for a top level on a large list cannot be split so as the list grows, the calculation becomes increasingly inefficient. Consider if you really need the total. If you need to have the totals, look to add intermediate parent “totals” to make the calculations more efficient, of use SUM to aggregate for…","categoryID":85,"dateInserted":"2020-05-20T12:09:11+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T03:31:05+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":51,"score":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/71182\/1-05-07-avoid-top-level-for-large-flat-lists","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/71182\/1-05-07-avoid-top-level-for-large-flat-lists","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":71181,"type":"discussion","name":"1.05-06 Only use Top Level for ultimate parent","excerpt":"Only use Top level for lists that will need sums so not Currency codes, or True\/False (Indicators), or children in composite lists Best Practices article: Top Level Item and Parent Hierarchy","categoryID":85,"dateInserted":"2020-05-20T12:09:00+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T03:26:00+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":1,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/71181\/1-05-06-only-use-top-level-for-ultimate-parent","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/71181\/1-05-06-only-use-top-level-for-ultimate-parent","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":70317,"type":"discussion","name":"1.02-01 Use \"Current\" in Version settings","excerpt":"Utilising the Current (and Actual) check box within the Version Settings allows the use of CURRENTVERSION() and ACTUALVERSION() in calculations, in SELECT statements and ISCURRENTVERSION and ISACTUALVERSION() for Boolean checks. Current version also acts like a top level for Versions; if you have a source module with…","categoryID":85,"dateInserted":"2020-05-13T14:52:50+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T03:16:04+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":91,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/70317\/1-02-01-use-current-in-version-settings","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/70317\/1-02-01-use-current-in-version-settings","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"},{"tagID":197,"urlcode":"Versions","name":"Versions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":70313,"type":"discussion","name":"1.01-04 Consider All Periods","excerpt":"Consider the use of All Periods. This is effectively the Top Level for time and whilst increasing the model cell count very slightly it does allow for flexibility in modelling. This is especially useful if you need to reference the same calculation many times","categoryID":85,"dateInserted":"2020-05-13T14:50:30+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T03:10:41+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":3,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/70313\/1-01-04-consider-all-periods","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/70313\/1-01-04-consider-all-periods","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":80784,"type":"discussion","name":"2.04-03 Keep the Default View clean","excerpt":"Keep the default view as is, no hiding line items, filtering, or conditional formatting","categoryID":85,"dateInserted":"2020-08-18T17:35:03+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T02:47:56+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":11,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/80784\/2-04-03-keep-the-default-view-clean","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/80784\/2-04-03-keep-the-default-view-clean","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":80771,"type":"discussion","name":"2.02-19 Don't daisy chain data","excerpt":"Always refer back to the ultimate source if possible, to avoid creating more dependencies than necessary. This allows more parallel calculations to be run increasing efficiency and speeding up calculations Best Practices article: Best Practices for Module Design","categoryID":85,"dateInserted":"2020-08-18T16:37:55+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T02:44:44+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":172,"score":1,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/80771\/2-02-19-dont-daisy-chain-data","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/80771\/2-02-19-dont-daisy-chain-data","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":80769,"type":"discussion","name":"2.02-17 Put the most common condition first","excerpt":"For formula efficiency, put the conditional with the most common occurrence first in the formula","categoryID":85,"dateInserted":"2020-08-18T16:35:37+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T02:39:44+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":11,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/80769\/2-02-17-put-the-most-common-condition-first","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/80769\/2-02-17-put-the-most-common-condition-first","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":80767,"type":"discussion","name":"2.02-15 FINDITEM on blanks","excerpt":"Doing a FINDITEM() on blank values is inefficient as the function has to traverse the entire list before it returns a blank. If the majority of the values are not blank, then check for BLANK first: * IF ISNOTBLANK(Line Item) THEN FINDITEM(List, line item) ELSE BLANK If the majority are NOT blank: * If ISNOTBLANK(Line Item)…","categoryID":85,"dateInserted":"2020-08-18T16:32:16+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T02:20:33+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":32,"score":1,"hot":3199806469,"url":"https:\/\/community.anaplan.com\/discussion\/80767\/2-02-15-finditem-on-blanks","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/80767\/2-02-15-finditem-on-blanks","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":80756,"type":"discussion","name":"2.02-08 Never use SUM and LOOKUP together","excerpt":"SUM and LOOKUP used in the same expression generally cause large formula calculations and may cause intermediate relationship calculations especially if Time is a dimension or when the source and target structures are very different. Splitting them into different modules and line items considerably reduces the size of the…","categoryID":85,"dateInserted":"2020-08-18T16:13:21+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T02:16:16+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":862,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/80756\/2-02-08-never-use-sum-and-lookup-together","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/80756\/2-02-08-never-use-sum-and-lookup-together","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":80749,"type":"discussion","name":"2.02-05 Create \"joins\" in smallest hierarchy","excerpt":"If a text string join is needed, create the joins in the smaller lists first to minimize the size of the text strings Related to Rule: 2.02-04 Text Strings Best Practice article: Formula Optimisation in Anaplan","categoryID":85,"dateInserted":"2020-08-18T16:06:58+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T02:09:12+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":54,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/80749\/2-02-05-create-joins-in-smallest-hierarchy","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/80749\/2-02-05-create-joins-in-smallest-hierarchy","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":80748,"type":"discussion","name":"2.02-04 Text Strings","excerpt":"Treat text strings with caution. Try and avoid multiple joins and split common joins to separate line items. Make use of IF ISBLANK() when joining text, if the strings are empty set to BLANK. Related to Rule: 2.02-05 Create \"joins\" in smallest hierarchy 2.03-02 Try not to use TEXT as a format, or limit it as much as…","categoryID":85,"dateInserted":"2020-08-18T16:04:25+00:00","dateUpdated":null,"dateLastComment":"2020-10-01T00:34:44+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":151,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/80748\/2-02-04-text-strings","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/80748\/2-02-04-text-strings","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">
"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":51,"score":null,"hot":3365324260,"url":"https:\/\/community.anaplan.com\/discussion\/155502\/options-to-improve-performance-when-loading-flat-list-used-in-reporting","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155502\/options-to-improve-performance-when-loading-flat-list-used-in-reporting","format":"Rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-04T07:54:57+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":136,"urlcode":"Performance","name":"Performance"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"},{"tagID":1143,"urlcode":"reporting","name":"reporting"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":71180,"type":"discussion","name":"1.05-05 Format the Display Name property as a list if possible","excerpt":"Format the Display Name property for Numbered lists as List Formatted, not text. This is more efficient, saves a line item, minimizes text fields and simplifies mappings. However, it not recommended to create a separate list purely for this purpose; use an existing list if possible","categoryID":85,"dateInserted":"2020-05-20T12:08:50+00:00","dateUpdated":null,"dateLastComment":"2023-04-22T12:54:10+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":240,"lastUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":191,"score":1,"hot":3272147880,"url":"https:\/\/community.anaplan.com\/discussion\/71180\/1-05-05-format-the-display-name-property-as-a-list-if-possible","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/71180\/1-05-05-format-the-display-name-property-as-a-list-if-possible","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":80762,"type":"discussion","name":"2.02-10 Using PREVIOUS() vs CUMULATE()","excerpt":"For long timescales, using PREVIOUS is faster than CUMULATE due to the number of \"reads\" required for the calculation. So, the expression should be: 'Calc line item' = 'data line item' + PREVIOUS('Calc line item') rather than CUMULATE('data line item') Exception: 2.02-10a Short Timescales: Where the number of periods is…","categoryID":85,"dateInserted":"2020-08-18T16:17:54+00:00","dateUpdated":null,"dateLastComment":"2023-04-21T07:22:37+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":102168,"lastUser":{"userID":102168,"name":"VRK96","url":"https:\/\/community.anaplan.com\/profile\/VRK96","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/UE02YVU2Q593\/n9VAUXA7D3LAU.jpg","dateLastActive":"2023-06-03T19:20:07+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":211,"score":1,"hot":3279830731,"url":"https:\/\/community.anaplan.com\/discussion\/80762\/2-02-10-using-previous-vs-cumulate","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/80762\/2-02-10-using-previous-vs-cumulate","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":71183,"type":"discussion","name":"1.05-08 Use Composite lists rather than ragged","excerpt":"Composite lists are more flexible and calculate more efficiently so try and \"balance\" the hierarchies whenever possible Exception: * 1.05-08a Chart of Accounts, or financial reporting hierarchies: Chart of Accounts, financial reporting hierarchies are valid uses of non-composite lists","categoryID":85,"dateInserted":"2020-05-20T12:10:01+00:00","dateUpdated":null,"dateLastComment":"2023-03-11T17:40:21+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":53001,"lastUser":{"userID":53001,"name":"LethargicAnalyst","url":"https:\/\/community.anaplan.com\/profile\/LethargicAnalyst","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/B7LHCABJPIV9\/n7UL9BZ487MRC.jpg","dateLastActive":"2023-06-15T14:27:32+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":252,"score":null,"hot":3268536622,"url":"https:\/\/community.anaplan.com\/discussion\/71183\/1-05-08-use-composite-lists-rather-than-ragged","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/71183\/1-05-08-use-composite-lists-rather-than-ragged","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":102615,"type":"discussion","name":"1.07-03 Turn summaries off on Collect() line items","excerpt":"By default, you should turn summaries off on line items using the Collect() function. By having summaries turned on, the system is aggregating data that is not usually needed. Related to Rule: 2.01-10 Calculation Modules 2.03-01 Turn Summary options off by default","categoryID":85,"dateInserted":"2021-03-22T10:12:31+00:00","dateUpdated":null,"dateLastComment":"2021-03-22T10:12:31+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":71,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/102615\/1-07-03-turn-summaries-off-on-collect-line-items","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/102615\/1-07-03-turn-summaries-off-on-collect-line-items","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":102586,"type":"discussion","name":"2.02-21 Don't use TIMESUM with Time","excerpt":"TIMESUM formulas should not be used in a line item that applies to Time, the formula will be duplicated for each time period. If the TIMESUM does use time periods then consider using MOVINGSUM instead. https:\/\/www.youtube.com\/watch?v=PvimWuX5jVw","categoryID":85,"dateInserted":"2021-03-22T07:31:29+00:00","dateUpdated":null,"dateLastComment":"2021-03-22T07:31:29+00:00","insertUserID":220,"insertUser":{"userID":220,"name":"MarkWarren","url":"https:\/\/community.anaplan.com\/profile\/MarkWarren","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/220.png","dateLastActive":"2023-06-08T16:11:47+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":121,"score":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/102586\/2-02-21-dont-use-timesum-with-time","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/102586\/2-02-21-dont-use-timesum-with-time","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/img.youtube.com\/vi\/PvimWuX5jVw\/0.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Untitled"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":93779,"type":"discussion","name":"Model Optimization Checklist","excerpt":"As your Anaplan platform grows and continues to expand beyond your initial use case, it remains just as important as it did on day one to make sure your models are built to perform and according to best practice. Check out the model optimization checklist to begin evaluating your models today!","categoryID":2,"dateInserted":"2020-12-18T06:15:32+00:00","dateUpdated":null,"dateLastComment":"2020-12-18T06:15:32+00:00","insertUserID":31571,"insertUser":{"userID":31571,"name":"CatherineH","url":"https:\/\/community.anaplan.com\/profile\/CatherineH","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/31571.jpeg","dateLastActive":"2023-06-15T13:01:43+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":1,"score":1,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/93779\/model-optimization-checklist","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/93779\/model-optimization-checklist","format":"html","groupID":51,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":2,"name":"Groups","url":"https:\/\/community.anaplan.com\/categories\/social-groups","allowedDiscussionTypes":["discussion","question","poll"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":90848,"type":"discussion","name":"5.04-11 Use zip files for faster imports","excerpt":"Anaplan will accept a zip file format as an import source. For large files, this will greatly improve the import speed","categoryID":85,"dateInserted":"2020-11-13T04:58:41+00:00","dateUpdated":null,"dateLastComment":"2020-11-13T04:58:41+00:00","insertUserID":157,"insertUser":{"userID":157,"name":"DavidSmith","url":"https:\/\/community.anaplan.com\/profile\/DavidSmith","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/157.jpeg","dateLastActive":"2023-05-10T18:49:38+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":92,"score":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/90848\/5-04-11-use-zip-files-for-faster-imports","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/90848\/5-04-11-use-zip-files-for-faster-imports","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":90844,"type":"discussion","name":"2.01-20 Use Appropriate Dimensions for modules","excerpt":"When creating a module, consider the scope of the calculation and only include the dimensions that are needed. If the formula doesn't return the value required, or errors, don't keep adding dimensions until it does; it is better to review the calculation itself. Check other modules; you may already have a calculation…","categoryID":85,"dateInserted":"2020-11-13T04:46:25+00:00","dateUpdated":null,"dateLastComment":"2020-11-13T04:46:25+00:00","insertUserID":157,"insertUser":{"userID":157,"name":"DavidSmith","url":"https:\/\/community.anaplan.com\/profile\/DavidSmith","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/157.jpeg","dateLastActive":"2023-05-10T18:49:38+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":21,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/90844\/2-01-20-use-appropriate-dimensions-for-modules","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/90844\/2-01-20-use-appropriate-dimensions-for-modules","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":90092,"type":"discussion","name":"2.01-19 Put Time and Versions list first in the dimension order","excerpt":"If you are using lists instead of native timescale or native versions, ensure these lists are placed as the first two lists in the dimension order. This mirrors the native time and version settings which will improve performance when mapping between native time\/versions and standard lists Best Practice Article: Dimension…","categoryID":85,"dateInserted":"2020-11-06T10:24:17+00:00","dateUpdated":null,"dateLastComment":"2020-11-06T10:24:17+00:00","insertUserID":157,"insertUser":{"userID":157,"name":"DavidSmith","url":"https:\/\/community.anaplan.com\/profile\/DavidSmith","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/157.jpeg","dateLastActive":"2023-05-10T18:49:38+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":11,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/90092\/2-01-19-put-time-and-versions-list-first-in-the-dimension-order","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/90092\/2-01-19-put-time-and-versions-list-first-in-the-dimension-order","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":90091,"type":"discussion","name":"2.01-18 Avoid copying large modules","excerpt":"Copying large modules, especially those with filters and many views, can take some time and block the model whilst doing so. For large modules, it is likely to be quicker to re-create the module Related to rule: 2.04-03: Keep the default view clean ","categoryID":85,"dateInserted":"2020-11-06T10:20:44+00:00","dateUpdated":null,"dateLastComment":"2020-11-06T10:20:44+00:00","insertUserID":157,"insertUser":{"userID":157,"name":"DavidSmith","url":"https:\/\/community.anaplan.com\/profile\/DavidSmith","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/157.jpeg","dateLastActive":"2023-05-10T18:49:38+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":1,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/90091\/2-01-18-avoid-copying-large-modules","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/90091\/2-01-18-avoid-copying-large-modules","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":90090,"type":"discussion","name":"1.02-05 Try and avoid a high number of native Versions","excerpt":"Versions have in built functionality that is not available for normal lists. However, a large number of Versions (e.g. 10+), can have performance implications due to the block structure and the lack of multi-threading available. Review the need for high number of Versions, and if the native functionality is not critical or…","categoryID":85,"dateInserted":"2020-11-06T09:55:47+00:00","dateUpdated":null,"dateLastComment":"2020-11-06T09:55:47+00:00","insertUserID":157,"insertUser":{"userID":157,"name":"DavidSmith","url":"https:\/\/community.anaplan.com\/profile\/DavidSmith","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/157.jpeg","dateLastActive":"2023-05-10T18:49:38+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":22,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/90090\/1-02-05-try-and-avoid-a-high-number-of-native-versions","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/90090\/1-02-05-try-and-avoid-a-high-number-of-native-versions","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"},{"tagID":197,"urlcode":"Versions","name":"Versions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":89877,"type":"discussion","name":"4.01-03 Create Output modules when using Custom Views","excerpt":"When staging line items are not needed to be viewed by the page builder, create an output module to be used for generating the Custom View Related to Rule: 2.01-04 Use the D.I.S.C.O. Methodology for Module Design ","categoryID":85,"dateInserted":"2020-11-04T12:21:11+00:00","dateUpdated":null,"dateLastComment":"2020-11-04T12:21:11+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":11,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/89877\/4-01-03-create-output-modules-when-using-custom-views","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/89877\/4-01-03-create-output-modules-when-using-custom-views","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":70316,"type":"discussion","name":"1.01-08 Daily Timescales on large timescales","excerpt":"Review the need for daily granularity for long timescales, specifically if the daily timescale spans five years or more. Use time ranges to restrict the daily calendars if possible and also use PREVIOUS rather than CUMULATE to optimise calculation efficiency. Related to Rule: 2.02-10 Using PREVIOUS vs. CUMULATE Best…","categoryID":85,"dateInserted":"2020-11-02T16:33:35+00:00","dateUpdated":null,"dateLastComment":"2020-11-02T16:33:35+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":31,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/70316\/1-01-08-daily-timescales-on-large-timescales","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/70316\/1-01-08-daily-timescales-on-large-timescales","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":70315,"type":"discussion","name":"1.01-07 Time Ranges","excerpt":"Use Time Ranges to optimize the modules where the default model calendar is not appropriate. Consider the dimensionality for the data and set up the Time Range accordingly. Best Practices article: Time Range Application","categoryID":85,"dateInserted":"2020-11-02T16:32:57+00:00","dateUpdated":null,"dateLastComment":"2020-11-02T16:32:57+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":11,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/70315\/1-01-07-time-ranges","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/70315\/1-01-07-time-ranges","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":71176,"type":"discussion","name":"1.01-05 Exclude timescale subtotals by default","excerpt":"Turn the \"include\" settings off by default and only include these if absolutely necessary. These additional settings (Quarter totals, Year to date, Year to go etc.) will be included in all modules with the model calendar as the time dimension. Thus they will perform calculations on these subtotals. Consider if you really…","categoryID":85,"dateInserted":"2020-11-02T11:27:21+00:00","dateUpdated":null,"dateLastComment":"2020-11-02T11:27:21+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":21,"score":3,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/71176\/1-01-05-exclude-timescale-subtotals-by-default","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/71176\/1-01-05-exclude-timescale-subtotals-by-default","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":71191,"type":"discussion","name":"1.06-03 Avoid single item subsets","excerpt":"If possible, try and avoid single item subsets, if there is a top level in the list, a single item subset will always have two members. Consider using a Boolean flag in a SYS module or a LOOKUP line item against the desired item (to avoid using SELECT)","categoryID":85,"dateInserted":"2020-05-20T12:16:06+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T03:43:17+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":103,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/71191\/1-06-03-avoid-single-item-subsets","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/71191\/1-06-03-avoid-single-item-subsets","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":71186,"type":"discussion","name":"1.05-11 Do not embed Numeric values or Dates within the Code of a list","excerpt":"Dates and values are \"data\" and should not be part of a code. Adding these elements to the code will in most cases, vastly increase the size of the list and consequently increase the mode size and reduce performance Best Practices article: Data Hubs Purpose and Peak Performance","categoryID":85,"dateInserted":"2020-05-20T12:10:45+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T03:40:43+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":41,"score":3,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/71186\/1-05-11-do-not-embed-numeric-values-or-dates-within-the-code-of-a-list","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/71186\/1-05-11-do-not-embed-numeric-values-or-dates-within-the-code-of-a-list","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":71182,"type":"discussion","name":"1.05-07 Avoid Top Level for large flat lists","excerpt":"The calculation for a top level on a large list cannot be split so as the list grows, the calculation becomes increasingly inefficient. Consider if you really need the total. If you need to have the totals, look to add intermediate parent “totals” to make the calculations more efficient, of use SUM to aggregate for…","categoryID":85,"dateInserted":"2020-05-20T12:09:11+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T03:31:05+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":51,"score":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/71182\/1-05-07-avoid-top-level-for-large-flat-lists","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/71182\/1-05-07-avoid-top-level-for-large-flat-lists","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":71181,"type":"discussion","name":"1.05-06 Only use Top Level for ultimate parent","excerpt":"Only use Top level for lists that will need sums so not Currency codes, or True\/False (Indicators), or children in composite lists Best Practices article: Top Level Item and Parent Hierarchy","categoryID":85,"dateInserted":"2020-05-20T12:09:00+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T03:26:00+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":1,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/71181\/1-05-06-only-use-top-level-for-ultimate-parent","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/71181\/1-05-06-only-use-top-level-for-ultimate-parent","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":70317,"type":"discussion","name":"1.02-01 Use \"Current\" in Version settings","excerpt":"Utilising the Current (and Actual) check box within the Version Settings allows the use of CURRENTVERSION() and ACTUALVERSION() in calculations, in SELECT statements and ISCURRENTVERSION and ISACTUALVERSION() for Boolean checks. Current version also acts like a top level for Versions; if you have a source module with…","categoryID":85,"dateInserted":"2020-05-13T14:52:50+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T03:16:04+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":91,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/70317\/1-02-01-use-current-in-version-settings","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/70317\/1-02-01-use-current-in-version-settings","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"},{"tagID":197,"urlcode":"Versions","name":"Versions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":70313,"type":"discussion","name":"1.01-04 Consider All Periods","excerpt":"Consider the use of All Periods. This is effectively the Top Level for time and whilst increasing the model cell count very slightly it does allow for flexibility in modelling. This is especially useful if you need to reference the same calculation many times","categoryID":85,"dateInserted":"2020-05-13T14:50:30+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T03:10:41+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":3,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/70313\/1-01-04-consider-all-periods","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/70313\/1-01-04-consider-all-periods","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":80784,"type":"discussion","name":"2.04-03 Keep the Default View clean","excerpt":"Keep the default view as is, no hiding line items, filtering, or conditional formatting","categoryID":85,"dateInserted":"2020-08-18T17:35:03+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T02:47:56+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":11,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/80784\/2-04-03-keep-the-default-view-clean","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/80784\/2-04-03-keep-the-default-view-clean","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":80771,"type":"discussion","name":"2.02-19 Don't daisy chain data","excerpt":"Always refer back to the ultimate source if possible, to avoid creating more dependencies than necessary. This allows more parallel calculations to be run increasing efficiency and speeding up calculations Best Practices article: Best Practices for Module Design","categoryID":85,"dateInserted":"2020-08-18T16:37:55+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T02:44:44+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":172,"score":1,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/80771\/2-02-19-dont-daisy-chain-data","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/80771\/2-02-19-dont-daisy-chain-data","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":80769,"type":"discussion","name":"2.02-17 Put the most common condition first","excerpt":"For formula efficiency, put the conditional with the most common occurrence first in the formula","categoryID":85,"dateInserted":"2020-08-18T16:35:37+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T02:39:44+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":11,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/80769\/2-02-17-put-the-most-common-condition-first","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/80769\/2-02-17-put-the-most-common-condition-first","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":80767,"type":"discussion","name":"2.02-15 FINDITEM on blanks","excerpt":"Doing a FINDITEM() on blank values is inefficient as the function has to traverse the entire list before it returns a blank. If the majority of the values are not blank, then check for BLANK first: * IF ISNOTBLANK(Line Item) THEN FINDITEM(List, line item) ELSE BLANK If the majority are NOT blank: * If ISNOTBLANK(Line Item)…","categoryID":85,"dateInserted":"2020-08-18T16:32:16+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T02:20:33+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":32,"score":1,"hot":3199806469,"url":"https:\/\/community.anaplan.com\/discussion\/80767\/2-02-15-finditem-on-blanks","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/80767\/2-02-15-finditem-on-blanks","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":80756,"type":"discussion","name":"2.02-08 Never use SUM and LOOKUP together","excerpt":"SUM and LOOKUP used in the same expression generally cause large formula calculations and may cause intermediate relationship calculations especially if Time is a dimension or when the source and target structures are very different. Splitting them into different modules and line items considerably reduces the size of the…","categoryID":85,"dateInserted":"2020-08-18T16:13:21+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T02:16:16+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":862,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/80756\/2-02-08-never-use-sum-and-lookup-together","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/80756\/2-02-08-never-use-sum-and-lookup-together","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":80749,"type":"discussion","name":"2.02-05 Create \"joins\" in smallest hierarchy","excerpt":"If a text string join is needed, create the joins in the smaller lists first to minimize the size of the text strings Related to Rule: 2.02-04 Text Strings Best Practice article: Formula Optimisation in Anaplan","categoryID":85,"dateInserted":"2020-08-18T16:06:58+00:00","dateUpdated":null,"dateLastComment":"2020-10-07T02:09:12+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":54,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/80749\/2-02-05-create-joins-in-smallest-hierarchy","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/80749\/2-02-05-create-joins-in-smallest-hierarchy","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":80748,"type":"discussion","name":"2.02-04 Text Strings","excerpt":"Treat text strings with caution. Try and avoid multiple joins and split common joins to separate line items. Make use of IF ISBLANK() when joining text, if the strings are empty set to BLANK. Related to Rule: 2.02-05 Create \"joins\" in smallest hierarchy 2.03-02 Try not to use TEXT as a format, or limit it as much as…","categoryID":85,"dateInserted":"2020-08-18T16:04:25+00:00","dateUpdated":null,"dateLastComment":"2020-10-01T00:34:44+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-06-16T16:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":151,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/80748\/2-02-04-text-strings","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/80748\/2-02-04-text-strings","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":85,"name":"Planual","url":"https:\/\/community.anaplan.com\/categories\/planual","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":136,"urlcode":"Performance","name":"Performance"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">
