社区知识库

"},"updateUserID":null,"lastUserID":17460,"lastUser":{"userID":17460,"name":"rohan.deo","url":"https:\/\/community.anaplan.com\/profile\/rohan.deo","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/17460.jpeg","dateLastActive":"2022-11-21T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":82,"score":23,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/151486\/first-look-formula-autocomplete","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/151486\/first-look-formula-autocomplete","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/eschera_0-1667859415296_151486.png?image-dimensions\/686x337\/****-exif-data\/true?v=v2","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"eschera_0-1667859415296.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":376,"urlcode":"How-to","name":"How to"}],"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":153499,"type":"discussion","name":"Build: Scrolling Sync","excerpt":"","categoryID":40,"dateInserted":"2022-12-05T10:42:43+00:00","dateUpdated":"2023-01-09T22:16:28+00:00","dateLastComment":"2022-12-05T10:42:43+00:00","insertUserID":22611,"insertUser":{"userID":22611,"name":"JamiesonC","url":"https:\/\/community.anaplan.com\/profile\/JamiesonC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22611.jpeg","dateLastActive":"2023-02-28T19:36:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":22611,"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":2,"score":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/153499\/build-scrolling-sync","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/153499\/build-scrolling-sync","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/cdn.vidyard.com\/thumbnails\/32383369\/j29Cp_vE_Q6dGZ80UVBJCbY4KI1-lsFG_play_button_small.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Scrolling sync"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":1091,"urlcode":"UX-Designer","name":"UX Designer"},{"tagID":1095,"urlcode":"quicktip","name":"Quick Tip"}],"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":153209,"type":"discussion","name":"Community perspective: Version compare and dynamic module line item description update","excerpt":"There are times when we need to generate output modules with the ability for version comparison. Although Anaplan has its own version comparison function, sometimes we need to build a dynamic scenario creation and comparison function. Please see Planual instructions for versions before proceeding with custom versions, as…","categoryID":40,"dateInserted":"2022-12-01T09:19:18+00:00","dateUpdated":"2023-01-11T19:29:30+00:00","dateLastComment":"2022-12-01T09:19:18+00:00","insertUserID":24895,"insertUser":{"userID":24895,"name":"SoumyaBhattacharyaMA","url":"https:\/\/community.anaplan.com\/profile\/SoumyaBhattacharyaMA","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/24895.jpeg","dateLastActive":"2023-01-11T22:33:30+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"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":24,"score":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/153209\/community-perspective-version-compare-and-dynamic-module-line-item-description-update","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/153209\/community-perspective-version-compare-and-dynamic-module-line-item-description-update","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/SoumyaBhattacharyaMA_0-1669852044425_153209.png?medium\/****-exif-data\/true?v=v2&px=400","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"SoumyaBhattacharyaMA_0-1669852044425.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":376,"urlcode":"How-to","name":"How to"},{"tagID":622,"urlcode":"Community-Perspectives","name":"Community Perspectives"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"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":153270,"type":"discussion","name":"Design: Create consistency throughout your apps","excerpt":"","categoryID":40,"dateInserted":"2022-12-01T07:40:24+00:00","dateUpdated":"2023-01-09T22:16:58+00:00","dateLastComment":"2022-12-01T07:40:24+00:00","insertUserID":22611,"insertUser":{"userID":22611,"name":"JamiesonC","url":"https:\/\/community.anaplan.com\/profile\/JamiesonC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22611.jpeg","dateLastActive":"2023-02-28T19:36:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":22611,"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":3,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/153270\/design-create-consistency-throughout-your-apps","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/153270\/design-create-consistency-throughout-your-apps","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/cdn.vidyard.com\/thumbnails\/28324311\/ojD3B_W1jVe1QibiLGmCI9cMZquAH19x_play_button_small.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Create consistency throughout your apps"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":1091,"urlcode":"UX-Designer","name":"UX Designer"},{"tagID":1095,"urlcode":"quicktip","name":"Quick Tip"}],"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":134991,"type":"discussion","name":"OEG Best Practice: Inside the Hyperblock","excerpt":"* What are blocks? * How blocks are calculated – General Lists * How blocks are calculated – Native Time\/Native Versions * Hyperblock performance * Summary block counts * Should I worry about blocks? * A reason why we shouldn’t focus on just the block count * Focus Points We recommend this article to Experienced Model…","categoryID":40,"dateInserted":"2022-03-31T08:34:13+00:00","dateUpdated":"2023-02-09T18:53:48+00:00","dateLastComment":"2022-11-30T06:45:37+00:00","insertUserID":101715,"insertUser":{"userID":101715,"name":"AnaplanOEG","url":"https:\/\/community.anaplan.com\/profile\/AnaplanOEG","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/AKCCM7USWMRM\/n1EGQRZGHE2WA.png","dateLastActive":"2023-02-14T17:14:29+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"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-03-01T20:18:47+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":322,"score":18,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/134991\/oeg-best-practice-inside-the-hyperblock","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/134991\/oeg-best-practice-inside-the-hyperblock","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/MarkWarren_0-1648723563074_134991.png?medium?v=v2&px=400","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"MarkWarren_0-1648723563074.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"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":151981,"type":"discussion","name":"PlanIQ: Introduction to forecast evaluation","excerpt":"Before making business decisions based on PlanIQ forecast results, you should assess the expected performance of the forecast predictions in the real world. It’s important to evaluate forecast performance at the outset of your project as well as on an ongoing basis. Also consider that a range of factors unique to your…","categoryID":40,"dateInserted":"2022-11-29T09:00:00+00:00","dateUpdated":"2023-01-11T18:49:51+00:00","dateLastComment":"2022-11-29T09:00:00+00:00","insertUserID":34718,"insertUser":{"userID":34718,"name":"NatalieC","url":"https:\/\/community.anaplan.com\/profile\/NatalieC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/34718.png","dateLastActive":"2022-11-23T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"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":41,"score":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/151981\/planiq-introduction-to-forecast-evaluation","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/151981\/planiq-introduction-to-forecast-evaluation","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/NatalieC_0-1668457356090_151981.png?image-dimensions\/699x348\/****-exif-data\/true?v=v2","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"NatalieC_0-1668457356090.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":99,"urlcode":"PlanIQ","name":"PlanIQ"},{"tagID":376,"urlcode":"How-to","name":"How to"}],"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":152586,"type":"discussion","name":"Community perspective: Add a timestamp to processes utilizing Anaplan API and Python","excerpt":"Anaplan is a critical tool for different business processes, and it is used to handle a variety of data. One key attribute for data quality is the timeliness and reliability of the data. It is a known best practice to use Data Hub for centralized data management and then import data to different spoke models. Even though…","categoryID":40,"dateInserted":"2022-11-28T14:06:48+00:00","dateUpdated":"2023-01-11T19:30:13+00:00","dateLastComment":"2022-11-28T14:06:48+00:00","insertUserID":71843,"insertUser":{"userID":71843,"name":"Lehtohen","url":"https:\/\/community.anaplan.com\/profile\/Lehtohen","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/71843.png","dateLastActive":"2023-01-25T09:06:57+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"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":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/152586\/community-perspective-add-a-timestamp-to-processes-utilizing-anaplan-api-and-python","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/152586\/community-perspective-add-a-timestamp-to-processes-utilizing-anaplan-api-and-python","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Lehtohen_1-1668950711116_152586.png?large\/****-exif-data\/true?v=v2&px=999","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Lehtohen_1-1668950711116.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":376,"urlcode":"How-to","name":"How to"},{"tagID":622,"urlcode":"Community-Perspectives","name":"Community Perspectives"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"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":133155,"type":"discussion","name":"OEG Best Practice: Data integration decision app","excerpt":"We built this app to make getting started on your Anaplan data integration journey simple with a quick questionnaire and helpful information and links. A common question that arises during Anaplan implementations (or even after go-live) is \"How can I automate data feeds into and out of Anaplan?\" While the ultimate decision…","categoryID":40,"dateInserted":"2022-03-03T08:04:54+00:00","dateUpdated":"2023-01-18T17:52:39+00:00","dateLastComment":"2022-11-25T07:51:49+00:00","insertUserID":101715,"insertUser":{"userID":101715,"name":"AnaplanOEG","url":"https:\/\/community.anaplan.com\/profile\/AnaplanOEG","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/AKCCM7USWMRM\/n1EGQRZGHE2WA.png","dateLastActive":"2023-02-14T17:14:29+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"lastUserID":40699,"lastUser":{"userID":40699,"name":"Aravindm","url":"https:\/\/community.anaplan.com\/profile\/Aravindm","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/40699.png","dateLastActive":"2023-02-14T16:46:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":146,"score":45,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/133155\/oeg-best-practice-data-integration-decision-app","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/133155\/oeg-best-practice-data-integration-decision-app","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/data-integration-decision-app.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"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":66364,"type":"discussion","name":"How to Create Connection Between Anaplan and Power BI with API 2.0","excerpt":"Power BI is a popular reporting tool. One of the reasons is that in Power BI you can get data from different sources, and there is an increased interest of our customers and Anaplan builders to be able to import data from Anaplan. In order to make this connection, we developed a solution to set up the integration. It is…","categoryID":40,"dateInserted":"2020-04-07T07:09:35+00:00","dateUpdated":"2023-01-09T21:45:28+00:00","dateLastComment":"2022-11-25T02:36:00+00:00","insertUserID":10376,"insertUser":{"userID":10376,"name":"ABerenguela","url":"https:\/\/community.anaplan.com\/profile\/ABerenguela","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/10376.jpeg","dateLastActive":"2022-11-03T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"lastUserID":71843,"lastUser":{"userID":71843,"name":"Lehtohen","url":"https:\/\/community.anaplan.com\/profile\/Lehtohen","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/71843.png","dateLastActive":"2023-01-25T09:06:57+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":94,"score":37,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/66364\/how-to-create-connection-between-anaplan-and-power-bi-with-api-2-0","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/66364\/how-to-create-connection-between-anaplan-and-power-bi-with-api-2-0","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/ABerenguela_0-1586265258047_66364.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ABerenguela_0-1586265258047.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":376,"urlcode":"How-to","name":"How to"},{"tagID":719,"urlcode":"Developer","name":"Developer"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"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":61097,"type":"discussion","name":"Compare TEXT Values in Anaplan","excerpt":"Technical Summary Statement The objective of this article is to compare values in a TEXT formatted line item and identify the values that occur more than once (duplicates). Problem Statement Sneakerz is an up-and-coming shoe company with a variety of shoe brands in its brand portfolio. They are expanding internationally…","categoryID":40,"dateInserted":"2020-02-20T09:25:33+00:00","dateUpdated":"2022-11-23T00:00:00+00:00","dateLastComment":"2022-11-23T04:41:15+00:00","insertUserID":7949,"insertUser":{"userID":7949,"name":"shreyak.garg","url":"https:\/\/community.anaplan.com\/profile\/shreyak.garg","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/7949.png","dateLastActive":"2023-02-03T04:39:19+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":2631,"lastUserID":84618,"lastUser":{"userID":84618,"name":"medaganeshamanikanta","url":"https:\/\/community.anaplan.com\/profile\/medaganeshamanikanta","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/84618.jpeg","dateLastActive":"2023-03-01T11:35:30+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":15,"score":4,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/61097\/compare-text-values-in-anaplan","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/61097\/compare-text-values-in-anaplan","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/HollyRieke_0-1585661039410_61097.png?medium?v=v2&px=400","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"HollyRieke_0-1585661039410.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":376,"urlcode":"How-to","name":"How to"}],"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":139838,"type":"discussion","name":"[Start here] Modeling Experience","excerpt":"As an Anaplan model builder, you are already familiar with the power and flexibility that the Anaplan platform provides when solving your team's planning needs. With the new Modeling Experience, we enhanced the Classic interface to improve the model-building experience. Just like before, this is still where you create your…","categoryID":40,"dateInserted":"2022-07-05T14:19:15+00:00","dateUpdated":"2023-02-13T15:11:41+00:00","dateLastComment":"2022-11-21T15:46:38+00:00","insertUserID":101715,"insertUser":{"userID":101715,"name":"AnaplanOEG","url":"https:\/\/community.anaplan.com\/profile\/AnaplanOEG","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/AKCCM7USWMRM\/n1EGQRZGHE2WA.png","dateLastActive":"2023-02-14T17:14:29+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":54173,"lastUserID":11099,"lastUser":{"userID":11099,"name":"eschera","url":"https:\/\/community.anaplan.com\/profile\/eschera","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/11099.jpeg","dateLastActive":"2022-11-21T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":13,"countViews":213,"score":7,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/139838\/start-here-modeling-experience","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/139838\/start-here-modeling-experience","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/NMX_Indent_139838.png?medium?v=v2&px=400","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"NMX Indent.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":376,"urlcode":"How-to","name":"How to"}],"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":56249,"type":"discussion","name":"Top Level Item and Parent Hierarchy","excerpt":"Lists in Anaplan have two main settings related to how data is aggregated: * Top Level Item * Parent Hierarchy They may both be set on the “Configure” tab on the List settings screen. Top Level item This list has been set to have a top level item, “All Regions.” When used in a module, the top level item contains the…","categoryID":40,"dateInserted":"2019-12-12T09:22:07+00:00","dateUpdated":"2022-11-21T00:00:00+00:00","dateLastComment":"2022-11-21T08:52:08+00:00","insertUserID":232,"insertUser":{"userID":232,"name":"greg_reynolds","url":"https:\/\/community.anaplan.com\/profile\/greg_reynolds","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/232.jpeg","dateLastActive":"2020-08-19T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":8029,"lastUser":{"userID":8029,"name":"Varchasva.Jain","url":"https:\/\/community.anaplan.com\/profile\/Varchasva.Jain","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8029.png","dateLastActive":"2023-02-18T09:13:12+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":209,"score":10,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/56249\/top-level-item-and-parent-hierarchy","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/56249\/top-level-item-and-parent-hierarchy","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/clipboard_image_0_56249.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"clipboard_image_0.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":376,"urlcode":"How-to","name":"How to"}],"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":151828,"type":"discussion","name":"[Part 1] Removing users in bulk: Approaches and challenges","excerpt":"* 1. Which users do you want to remove? * 2. What do these users currently have access to? * 3. What level of removal do you need to perform? * 4. How will you go about removing the users? * Users tab * User administration * SCIM API Script * Conclusion * Additional resources There are several things to consider when…","categoryID":40,"dateInserted":"2022-11-18T08:00:00+00:00","dateUpdated":"2022-11-19T00:00:00+00:00","dateLastComment":"2022-11-19T14:12:53+00:00","insertUserID":365,"insertUser":{"userID":365,"name":"ryan_kohn","url":"https:\/\/community.anaplan.com\/profile\/ryan_kohn","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/365.jpeg","dateLastActive":"2023-03-01T15:57:52+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":74839,"lastUser":{"userID":74839,"name":"ManjunathKN","url":"https:\/\/community.anaplan.com\/profile\/ManjunathKN","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/74839.jpeg","dateLastActive":"2023-02-27T11:42:42+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":104,"score":7,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/151828\/part-1-removing-users-in-bulk-approaches-and-challenges","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/151828\/part-1-removing-users-in-bulk-approaches-and-challenges","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/ryan_kohn_0-1668459076173_151828.png?image-dimensions\/715x536\/****-exif-data\/true?v=v2","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ryan_kohn_0-1668459076173.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":376,"urlcode":"How-to","name":"How to"}],"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":152498,"type":"discussion","name":"Build: Forms","excerpt":"","categoryID":40,"dateInserted":"2022-11-18T08:51:24+00:00","dateUpdated":"2023-01-09T22:17:30+00:00","dateLastComment":"2022-11-18T08:51:24+00:00","insertUserID":22611,"insertUser":{"userID":22611,"name":"JamiesonC","url":"https:\/\/community.anaplan.com\/profile\/JamiesonC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22611.jpeg","dateLastActive":"2023-02-28T19:36:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":22611,"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":2,"score":1,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/152498\/build-forms","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/152498\/build-forms","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/cdn.vidyard.com\/thumbnails\/32523415\/1pxcY58i4iIkqFmVgFzjX4n-nBGXdik3_play_button_small.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Forms"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":1091,"urlcode":"UX-Designer","name":"UX Designer"},{"tagID":1095,"urlcode":"quicktip","name":"Quick Tip"}],"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":94700,"type":"discussion","name":"Workarounds To Sum Data While Using NONE as Summary Method Within Source Module","excerpt":"As the Anaplan model size capacity has recently grown from roughly 18 billion cells to 100 billion cells with the introduction of HyperModel, it is still important to structure models efficiently, while creating as little 'wasted space' as possible. The Planual states that the Summary Method for most line items should be…","categoryID":40,"dateInserted":"2021-01-07T07:03:13+00:00","dateUpdated":"2022-11-14T00:00:00+00:00","dateLastComment":"2022-11-14T19:29:36+00:00","insertUserID":477,"insertUser":{"userID":477,"name":"jczimbal","url":"https:\/\/community.anaplan.com\/profile\/jczimbal","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/477.png","dateLastActive":"2022-08-10T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":22331,"lastUser":{"userID":22331,"name":"AmyX","url":"https:\/\/community.anaplan.com\/profile\/AmyX","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22331.jpeg","dateLastActive":"2023-03-01T08:00:55+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":36,"score":6,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/94700\/workarounds-to-sum-data-while-using-none-as-summary-method-within-source-module","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/94700\/workarounds-to-sum-data-while-using-none-as-summary-method-within-source-module","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Example_1_Source_Data_94700.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Example 1 Source Data.JPG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":376,"urlcode":"How-to","name":"How to"}],"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":151958,"type":"discussion","name":"Using Show and Hide on non-nested grids","excerpt":"","categoryID":40,"dateInserted":"2022-11-14T08:37:12+00:00","dateUpdated":"2023-01-09T22:18:03+00:00","dateLastComment":"2022-11-14T08:45:38+00:00","insertUserID":22611,"insertUser":{"userID":22611,"name":"JamiesonC","url":"https:\/\/community.anaplan.com\/profile\/JamiesonC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22611.jpeg","dateLastActive":"2023-02-28T19:36:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":22611,"lastUserID":4770,"lastUser":{"userID":4770,"name":"andrewtye","url":"https:\/\/community.anaplan.com\/profile\/andrewtye","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4770.jpeg","dateLastActive":"2023-03-01T18:52:32+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":1,"score":3,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/151958\/using-show-and-hide-on-non-nested-grids","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/151958\/using-show-and-hide-on-non-nested-grids","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/cdn.vidyard.com\/thumbnails\/28324883\/-jFrsh0Wt0hkNn4HA5v118RyGoMnGiK-_play_button_small.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Using Show and Hide on non-nested grids"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":1091,"urlcode":"UX-Designer","name":"UX Designer"},{"tagID":1095,"urlcode":"quicktip","name":"Quick Tip"}],"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":151956,"type":"discussion","name":"End User Features: Auto Refresh vs Manual Refresh","excerpt":"","categoryID":40,"dateInserted":"2022-11-14T08:35:36+00:00","dateUpdated":"2023-01-09T22:19:01+00:00","dateLastComment":"2022-11-14T08:35:36+00:00","insertUserID":22611,"insertUser":{"userID":22611,"name":"JamiesonC","url":"https:\/\/community.anaplan.com\/profile\/JamiesonC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22611.jpeg","dateLastActive":"2023-02-28T19:36:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":22611,"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\/151956\/end-user-features-auto-refresh-vs-manual-refresh","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/151956\/end-user-features-auto-refresh-vs-manual-refresh","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/cdn.vidyard.com\/thumbnails\/32383363\/btlW_HPVm9yrM2Y6duFTlpN7F_akwCqR_play_button_small.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Auto Refresh vs Manual Refresh"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":1091,"urlcode":"UX-Designer","name":"UX Designer"},{"tagID":1095,"urlcode":"quicktip","name":"Quick Tip"}],"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":150867,"type":"discussion","name":"Demystify non-linear optimization: Episode 2","excerpt":"Episode 2: Changeover optimization In Episode 1, we discussed how to configure optimizer to evaluate IF-THEN logic and multiplication of two binary variables. In this episode, we will be discussing how to solve a changeover issue for the beverage manufacturer. Changeover on a production line happens when the production…","categoryID":40,"dateInserted":"2022-11-02T15:43:01+00:00","dateUpdated":"2023-01-18T16:28:56+00:00","dateLastComment":"2022-11-02T15:43:01+00:00","insertUserID":1507,"insertUser":{"userID":1507,"name":"anikdas","url":"https:\/\/community.anaplan.com\/profile\/anikdas","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/1507.png","dateLastActive":"2023-03-01T01:21:05+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":2631,"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":28,"score":5,"hot":3341464617,"url":"https:\/\/community.anaplan.com\/discussion\/150867\/demystify-non-linear-optimization-episode-2","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/150867\/demystify-non-linear-optimization-episode-2","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":215,"urlcode":"Intelligence","name":"Intelligence"},{"tagID":376,"urlcode":"How-to","name":"How to"}],"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":150063,"type":"discussion","name":"In-app help for end users","excerpt":"A customer recently asked me, “What ease of use features are available in the Anaplan user experience (UX) to help drive end user adoption and engagement?” The customer was about to roll out Anaplan to a large number of first-time Anaplan stakeholders and wanted to do everything possible to ensure excellent end user…","categoryID":40,"dateInserted":"2022-10-27T14:42:39+00:00","dateUpdated":"2023-02-14T14:13:59+00:00","dateLastComment":"2022-11-01T01:53:08+00:00","insertUserID":11122,"insertUser":{"userID":11122,"name":"ChrisStauffer","url":"https:\/\/community.anaplan.com\/profile\/ChrisStauffer","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/11122.png","dateLastActive":"2023-03-01T13:53:13+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":11122,"lastUserID":17053,"lastUser":{"userID":17053,"name":"david.savarin","url":"https:\/\/community.anaplan.com\/profile\/david.savarin","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/17053.jpeg","dateLastActive":"2023-02-27T22:52:28+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":17,"score":9,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/150063\/in-app-help-for-end-users","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/150063\/in-app-help-for-end-users","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/1_150063.jpg?large?v=v2&px=999","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"1.jpg"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":376,"urlcode":"How-to","name":"How to"}],"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":150746,"type":"discussion","name":"Design: Design for your end users","excerpt":"","categoryID":40,"dateInserted":"2022-10-31T14:17:46+00:00","dateUpdated":"2023-01-10T14:55:25+00:00","dateLastComment":"2022-10-31T14:17:46+00:00","insertUserID":22611,"insertUser":{"userID":22611,"name":"JamiesonC","url":"https:\/\/community.anaplan.com\/profile\/JamiesonC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22611.jpeg","dateLastActive":"2023-02-28T19:36:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":22611,"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":3,"score":1,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/150746\/design-design-for-your-end-users","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/150746\/design-design-for-your-end-users","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/cdn.vidyard.com\/thumbnails\/29331139\/rUwa6UBXBRor_7IQlvOp11TN7jb3qf9j_play_button_small.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Design for your end users"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":1091,"urlcode":"UX-Designer","name":"UX Designer"},{"tagID":1095,"urlcode":"quicktip","name":"Quick Tip"}],"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":150043,"type":"discussion","name":"Community Perspective: Using OAUTH2 to develop custom Anaplan connector for Azure","excerpt":"Introduction The release of OAUTH2 authentication for the Anaplan API opens the door to developing more native connectors across all the major cloud platforms. In this article, I explain how you can configure a custom connector on Azure for use in Logic Apps. The benefit of a custom connector is that you can expose all the…","categoryID":40,"dateInserted":"2022-10-31T09:00:00+00:00","dateUpdated":null,"dateLastComment":"2022-10-31T09:00:00+00:00","insertUserID":2076,"insertUser":{"userID":2076,"name":"sean_culligan","url":"https:\/\/community.anaplan.com\/profile\/sean_culligan","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/2076.jpeg","dateLastActive":"2023-01-17T11:43:18+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":19,"score":6,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/150043\/community-perspective-using-oauth2-to-develop-custom-anaplan-connector-for-azure","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/150043\/community-perspective-using-oauth2-to-develop-custom-anaplan-connector-for-azure","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/sean_culligan_17-1666347663047_150043.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"sean_culligan_17-1666347663047.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":376,"urlcode":"How-to","name":"How to"},{"tagID":622,"urlcode":"Community-Perspectives","name":"Community Perspectives"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"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":146529,"type":"discussion","name":"Community perspective: How to maintain corporate brand standards in Anaplan","excerpt":"Overview One responsibility of a marketing team is creating and regulating the corporate brand standards. Logos represent the most recognizable part of this tool kit, but the choice in color can be equally important when consumers are challenged with recognizing popular companies. McDonalds: Red & Yellow. Starbucks: Green…","categoryID":40,"dateInserted":"2022-09-12T08:29:44+00:00","dateUpdated":null,"dateLastComment":"2022-10-31T07:39:37+00:00","insertUserID":16580,"insertUser":{"userID":16580,"name":"kaitchura","url":"https:\/\/community.anaplan.com\/profile\/kaitchura","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/16580.jpeg","dateLastActive":"2022-11-21T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":22606,"lastUser":{"userID":22606,"name":"KBeltz","url":"https:\/\/community.anaplan.com\/profile\/KBeltz","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22606.png","dateLastActive":"2023-03-01T17:42:31+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":4,"score":15,"hot":3330180861,"url":"https:\/\/community.anaplan.com\/discussion\/146529\/community-perspective-how-to-maintain-corporate-brand-standards-in-anaplan","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/146529\/community-perspective-how-to-maintain-corporate-brand-standards-in-anaplan","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Screen_Shot_2022-09-08_at_12.24.12_PM_146529.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2022-09-08 at 12.24.12 PM.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":376,"urlcode":"How-to","name":"How to"},{"tagID":622,"urlcode":"Community-Perspectives","name":"Community Perspectives"},{"tagID":1123,"urlcode":"user-experience","name":"User Experience"}],"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":48352,"type":"discussion","name":"OEG Best Practice: Pre-allocation in lists (and impacts to model performance)","excerpt":"What is pre-allocation in lists? Pre-allocation in lists is a mechanism in Anaplan that adds a buffer to list lengths. It is not added by default for lists; it becomes enabled when a role is set on a list. Please follow 1.03-01 though. Only add roles when needed. When it is enabled, a 2 percent buffer is added to the list,…","categoryID":40,"dateInserted":"2019-07-09T02:21:31+00:00","dateUpdated":"2023-02-09T18:13:19+00:00","dateLastComment":"2022-10-29T17:26:58+00:00","insertUserID":101715,"insertUser":{"userID":101715,"name":"AnaplanOEG","url":"https:\/\/community.anaplan.com\/profile\/AnaplanOEG","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/AKCCM7USWMRM\/n1EGQRZGHE2WA.png","dateLastActive":"2023-02-14T17:14:29+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"lastUserID":28134,"lastUser":{"userID":28134,"name":"LilyLiuAnaplan","url":"https:\/\/community.anaplan.com\/profile\/LilyLiuAnaplan","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28134.png","dateLastActive":"2023-02-18T20:30:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":91,"score":4,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/48352\/oeg-best-practice-pre-allocation-in-lists-and-impacts-to-model-performance","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/48352\/oeg-best-practice-pre-allocation-in-lists-and-impacts-to-model-performance","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/pre1_48352.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"pre1.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"}],"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":149999,"type":"discussion","name":"Community perspective: Monitor activity in your models using an action log","excerpt":"Model actions are a useful tool when it comes to automating routine tasks in Anaplan. They enable a wide range of applications such as data integration, list management, or model maintenance. To keep track of action-related activity in a model, we can rely on the Start Date and Time (UTC) column in the Actions pane: A…","categoryID":40,"dateInserted":"2022-10-26T09:00:00+00:00","dateUpdated":null,"dateLastComment":"2022-10-26T09:00:00+00:00","insertUserID":14704,"insertUser":{"userID":14704,"name":"Guillaume_D","url":"https:\/\/community.anaplan.com\/profile\/Guillaume_D","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14704.jpeg","dateLastActive":"2023-02-03T00:45:41+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":48,"score":8,"hot":1666777200,"url":"https:\/\/community.anaplan.com\/discussion\/149999\/community-perspective-monitor-activity-in-your-models-using-an-action-log","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/149999\/community-perspective-monitor-activity-in-your-models-using-an-action-log","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/2022-10-20_20_45_51-Action_Log_Demo___Anaplan_and_20_more_pages_-_Work_-_Microsoft​_Edge_149999.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2022-10-20 20_45_51-Action Log Demo _ Anaplan and 20 more pages - Work - Microsoft​ Edge.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":26,"urlcode":"Security-and-Administration","name":"Security and Administration"},{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":376,"urlcode":"How-to","name":"How to"},{"tagID":622,"urlcode":"Community-Perspectives","name":"Community Perspectives"}],"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":150145,"type":"discussion","name":"Build: Using the Dashboard Import Tool to migrate from Classic to UX","excerpt":"","categoryID":40,"dateInserted":"2022-10-24T09:11:05+00:00","dateUpdated":"2023-01-10T14:56:12+00:00","dateLastComment":"2022-10-24T09:11:05+00:00","insertUserID":22611,"insertUser":{"userID":22611,"name":"JamiesonC","url":"https:\/\/community.anaplan.com\/profile\/JamiesonC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22611.jpeg","dateLastActive":"2023-02-28T19:36:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":22611,"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":4,"score":1,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/150145\/build-using-the-dashboard-import-tool-to-migrate-from-classic-to-ux","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/150145\/build-using-the-dashboard-import-tool-to-migrate-from-classic-to-ux","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/cdn.vidyard.com\/thumbnails\/28320561\/Tqxlr18xavJs7Zygnxn4qSsN-wx-oWse_play_button_small.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Using the Dashboard Import Tool to migrate from Classic to UX"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":1091,"urlcode":"UX-Designer","name":"UX Designer"},{"tagID":1095,"urlcode":"quicktip","name":"Quick Tip"}],"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":120636,"type":"discussion","name":"Easily Get Current Date Using CloudWorks","excerpt":"Almost any model builder has had to come up with a solution to get the current date in Anaplan. We used to build integrations and use API for that. @JaredDolich posted a great article about using python for getting today's date. But this approach has some cons: * You must learn to code or involve someone who can do it.…","categoryID":40,"dateInserted":"2021-09-30T06:19:51+00:00","dateUpdated":null,"dateLastComment":"2022-10-23T20:07:27+00:00","insertUserID":9870,"insertUser":{"userID":9870,"name":"Hayk","url":"https:\/\/community.anaplan.com\/profile\/Hayk","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9870.jpeg","dateLastActive":"2023-02-11T09:00:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":36817,"lastUser":{"userID":36817,"name":"matthewreed","url":"https:\/\/community.anaplan.com\/profile\/matthewreed","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/36817.jpeg","dateLastActive":"2023-03-01T07:50:19+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":175,"score":24,"hot":3299551038,"url":"https:\/\/community.anaplan.com\/discussion\/120636\/easily-get-current-date-using-cloudworks","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/120636\/easily-get-current-date-using-cloudworks","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Hayk_0-1629440853340_120636.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Hayk_0-1629440853340.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":376,"urlcode":"How-to","name":"How to"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"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":143344,"type":"discussion","name":"[Part 2] Using line item subsets for dynamic error messages for user input validation","excerpt":"* Step 1: Create a module for your error messages * Step 2: Create your line item subset * Step 3: Create a System module to store metadata associated with the validations * Step 4: Create a module and use COLLECT to summarize error information * Step 5: Create an Output module to display the error messages and other…","categoryID":40,"dateInserted":"2022-08-04T08:00:00+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T13:31:35+00:00","insertUserID":365,"insertUser":{"userID":365,"name":"ryan_kohn","url":"https:\/\/community.anaplan.com\/profile\/ryan_kohn","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/365.jpeg","dateLastActive":"2023-03-01T15:57:52+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":62918,"lastUser":{"userID":62918,"name":"ShubhamCh","url":"https:\/\/community.anaplan.com\/profile\/ShubhamCh","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/62918.jpeg","dateLastActive":"2023-02-23T17:27:52+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":13,"score":13,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/143344\/part-2-using-line-item-subsets-for-dynamic-error-messages-for-user-input-validation","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/143344\/part-2-using-line-item-subsets-for-dynamic-error-messages-for-user-input-validation","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/post-image\/ryan_kohn_1-1658957207665.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ryan_kohn_1-1658957207665.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":376,"urlcode":"How-to","name":"How to"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"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":149530,"type":"discussion","name":"Design: Use shapes and icons","excerpt":"","categoryID":40,"dateInserted":"2022-10-17T13:32:13+00:00","dateUpdated":"2023-01-10T14:59:05+00:00","dateLastComment":"2022-10-17T13:32:13+00:00","insertUserID":22611,"insertUser":{"userID":22611,"name":"JamiesonC","url":"https:\/\/community.anaplan.com\/profile\/JamiesonC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22611.jpeg","dateLastActive":"2023-02-28T19:36:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":22611,"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":2,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/149530\/design-use-shapes-and-icons","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/149530\/design-use-shapes-and-icons","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/cdn.vidyard.com\/thumbnails\/28320561\/Tqxlr18xavJs7Zygnxn4qSsN-wx-oWse_play_button_small.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Using the Dashboard Import Tool to migrate from Classic to UX"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":1091,"urlcode":"UX-Designer","name":"UX Designer"},{"tagID":1095,"urlcode":"quicktip","name":"Quick Tip"}],"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":32934,"type":"discussion","name":"OEG Best Practice: Dimension order","excerpt":"Dimension order affects calculation performance Ensuring consistency in the order of dimensions will help improve the performance of your models. This consistency is relevant for modules and individual line items. Why does the order matter? Anaplan creates and uses indexes to perform calculations. Each cell in a module…","categoryID":40,"dateInserted":"2018-05-04T06:20:51+00:00","dateUpdated":"2023-02-09T21:46:45+00:00","dateLastComment":"2022-10-17T13:23:58+00:00","insertUserID":101715,"insertUser":{"userID":101715,"name":"AnaplanOEG","url":"https:\/\/community.anaplan.com\/profile\/AnaplanOEG","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/AKCCM7USWMRM\/n1EGQRZGHE2WA.png","dateLastActive":"2023-02-14T17:14:29+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"lastUserID":8359,"lastUser":{"userID":8359,"name":"Joshua.Huilar","url":"https:\/\/community.anaplan.com\/profile\/Joshua.Huilar","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8359.jpeg","dateLastActive":"2022-11-10T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":14,"countViews":219,"score":29,"hot":3201411156,"url":"https:\/\/community.anaplan.com\/discussion\/32934\/oeg-best-practice-dimension-order","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/32934\/oeg-best-practice-dimension-order","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/DimensionOrder_1_32934.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"DimensionOrder_1.jpg"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"}],"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":146489,"type":"discussion","name":"Community perspective: RANK and row counts – Management Reporting with multiple lists","excerpt":"A common request within any planning project is to create well-formatted, standard reports for the business to consume. However, these aren’t always as simple to create as first thought. The Management Reporting capabilities within Anaplan produce great looking outputs. However, they require a fixed number of rows for each…","categoryID":40,"dateInserted":"2022-09-15T07:37:04+00:00","dateUpdated":null,"dateLastComment":"2022-10-11T23:18:19+00:00","insertUserID":29455,"insertUser":{"userID":29455,"name":"maxst","url":"https:\/\/community.anaplan.com\/profile\/maxst","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/29455.jpeg","dateLastActive":"2023-02-20T15:30:20+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":54708,"lastUser":{"userID":54708,"name":"TomClark","url":"https:\/\/community.anaplan.com\/profile\/TomClark","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/54708.svg","dateLastActive":"2022-10-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":3,"score":7,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/146489\/community-perspective-rank-and-row-counts-management-reporting-with-multiple-lists","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/146489\/community-perspective-rank-and-row-counts-management-reporting-with-multiple-lists","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Trading_Report_page_1_146489.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Report page 1"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":376,"urlcode":"How-to","name":"How to"},{"tagID":622,"urlcode":"Community-Perspectives","name":"Community Perspectives"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"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}">